Get your MONEY under CONTROL | Building a FINANCIAL STATEMENT with Calculation Groups in Power BI
Vložit
- čas přidán 1. 08. 2024
- In this video I show you how to create a financial statement using calculation groups. A feature that opens up many possibilities within Power BI and allows you to work more efficiently.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:55 Creating the main structure
05:15 Adding minus signs in front of expenses
05:55 Creating a breakdown over time
06:24 Adding percentage and difference columns
09:48 Improving the design
12:43 Add conditional formatting
17:16 Adding empty lines
19:10 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Věda a technologie
This is the best approach!
As always a great video! Thanks for sharing all this knowledge
Excellent as always, good to see it done in a couple of different ways! Thanks!
Thanks Kyle!
thx for your videos. just the best trader on yt
this is great Bas! Thanks a lot
Than you for this
This video is so great :) Thank you! I'm trying to pull in budget values as well. Any ideas on how to do this?
Is there any way to then drill down into a given row like sales?
Loving these financial reporting videos!Currently trying to build my own for work, but with added complexity of multiple companies (filterable) and also to drill down into transaction level data.
This video is amazing , thank you the explanation it is very useful for me , I like your video
Merci beaucoup :)
Thanks for the video. Question for you... Is there a way to have conditional formatting for the background or icons using 2 calculation groups?
Hi Bas! I have been following your advance matrix video but what if we want to add a additional columns in an Matrix visual like if the in my matrix I have groups the days from (0-30 days,31 -60 days so on) the addition of (overdues) appears at last but I just wanna add a column to it call (not due) and finally want to add the both (Overdues and Not due ) column into a (Total Receivable column) all measures are been evaluated I just want to add this 2 (Not due and total receivable to Matrix visual what I have made)
Hope you got what I'm trying to explain.
I'm preparing a Receivable Dashboard.
If I need to coach a team of inexperienced PowerBI users to build/maintain their financial statements (I might leave for another job), what's the simplest and easiest way to build FS? Thanks
Really enjoying series. However I would like to understand how you would also add a Budget column into the statement rather than calculating values off just a single Value column. I've had to duplicate all the base level calculation items in order to have the 2 base measures. I'm pretty sure there must be a more efficient way to do this than that..
Hi Bas, Awasome video, Very informative and your style of explanation with energy is unique. i followed each and every step and was able to reach till the creation of layout with space, I have created measure for first line item of Financial Structure, My first item on my layout is Sales volume instead of Sales and i was able to get the figures in my report. Since i am having sub category for sales, hear i am stuck. her, i created measure and also incorporated in Financial value, the out put in report is not showing the value, i cross check the measure. but i am not able to figure out, appreciate if you can make video for creation of sub-category and also for balance sheet it will be great.
How can i make the structure more flexible? Allowing for different views when presenting to different groups
How can i make use of the new field parameters to do the same?
I have blank rows in both my first date & last date. Also I have a condition for my second date where, if its blank then I need to consider another date column. on top of it, I need to remove the Saturdays and Sundays. Also my start date is greater than end date. Can you suggest any solution for this.
I used your video about building a financial report and now watching this. Is it possible to make different values bold? I use format within the switch function to create percentages e.g, but to make them stand out in the rows I would like to use more format options.
making values conditionally bold is still not possible :(
Can you please attached the previous tutorial video link you mentioned in the Video.
here you go czcams.com/video/J4317R5BvsA/video.html
OMG I've been dealing with that formatting problem for so long "Type text something.." ¿how can I find more documentation about ?
Hi Bas, i did something similar for my task, but then i was asked to make it as hierarchy. I kind of have what they asked now but it is soooooo slow. And advice how to approach this differently?
My matrix is mixing things from different hierarchies in the model (and different levels in these hierarchies). For that I'm using "contain string" on path column in each hierarchy. 2 hierarchies are running smoothly, but third one is the biggest and slows everything to the point that I can't go with that into production..
Help?:)
That search is going to be expensive. I would add something to the model to make it easier
if unable to use tabular editor in office environment, can i download pbix file to a home pc and use tabular editor on that to create calculation group and later replace the office one.
sure, will work. However, I'm not sure if you are breaking then some data/it policies of your company
There is a portable version of tabular editor. You should be able to use that one as you don’t have to install it. I do the same thing. You can not start it from the external tools menu but that is the only downside. You can still connect to your model from the menu in tabular editor.
Nvm i manage to get portable version of tabular editor.
Hai sir and all viewers , any one plz guide me i want percentages each line below (row based) example operating expenses below row % operating expenses on sales
By the miniature I thought you would teach us how to launder money 😂😂
Too complicated for normal people.