Dynamic Results vs Budgets & Last Year - Power BI Financial Reporting Techniques

This reason completing financial reporting within Power BI is so compelling now, is because you can bring in many DAX and visualization techniques to your analysis.

In this example, I showcase how you can dynamically view the results based on a selection from a slicer.

This technique can be used in so many scenarios around financial reporting, so worth-learning if this is your focus.

****Video Details****
0:59 - sample financial report in Power BI
2:12 - budget data
2:26 - last year data
3:10 - creating a table for comparison
4:55 - using SWITCH formula
6:28 - calculating the percentage of difference

***** Learning Power BI? *****

*****Related Links*****

*****Related Course Modules*****

*****Related Forum Posts*****

[yogeshmahadnac]

Hey Sam! Thanks for this video; I have been using this method of doing dynamic comparison since many months now :-)
Thanks also for your daily videos. They are always very helpful and instructive!
Looking forward to your next ones!
Have a great day!

[kumarshourabh]

I am working on building a similar kind of dashboard for the first time. But, I am not sure how to get the other measures on the rows ( like here, they have Revenue, Expenses measures on rows and the columns have the Actual and Forecasts). I would really apprecaite if you help me with a sample PBIX file or any links/articles.

[bhochannel]

If I would like to learn more in detail of kind like this vdo such as how to prepare data etc. What is course you have ? Pls introduce.