Financial Reporting w/ Power BI DAX questions

DAX DAX Calculations
1

Hello, I had a quick question related to the selected year actuals formulas for previous years calculations. Why on the selected year actuals LY formula did you go through and recreate each of the income statement formulas when you could have just taken the selected year actuals and dateadd that. It seems like that would be more efficient. I got the same values with both ways. I am not all the way through the course, so my apologies if the reasoning becomes evident in a later part of the course.

image
image831Ă—144 7.02 KB

image
image
image831Ă—295 13.1 KB

Thanks!
Nick

2

I think I see why in the next video. It looks like you had to do it that way due to the margin percentage formatting piece. Let me know if that is not it. If it is, please feel free to mark this as solved or I can delete the post.

Thanks,

Nick

3

Creating a date table will make it easy for you.

Please look at the following free video.

4

Hi @nickjordan32

Your understanding is correct. If we create a measure like below and use in report, then all the Dynamic formatting will be lost

Selected Year Actuals LY =
CALCULATE ( [Selected Year Actuals], DATEADD ( Dates[Date], -1, YEAR ) )

Thanks
Ankit J

1 Like
5

Hi @nickjordan32, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!