topic Re: Using Calculate with DateAdd in DAX Commands and Tips

Using Calculate with DateAdd

Anonymous — Wed, 18 Jan 2023 14:53:03 GMT

Hello all.

I have been having difficulties using the Calculate function in addition to the DateAdd.

In this example, I am not getting any results with the DAX formula as you can see in the highlighted column. Ignore the arrow on the Months please.

Then in this example, how can I use the Budget PL Group as a variable in the DAX formula? Should I transform it to a Measure first in order to use it in the Calculate?

For the columns in the table that are Measure (REVENUE TOTAL and CONFIRMED REVENUE) the row Total is not appearing filled. Why is that and how can I change it?

Best regards,

Bernardo Macieira

Re: Using Calculate with DateAdd

amitchandak — Wed, 18 Jan 2023 17:21:53 GMT

Anonymous , Use sum(Table[Budget PL Group]) in the expression

refer Why TI do not work

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Re: Using Calculate with DateAdd

Anonymous — Wed, 18 Jan 2023 18:54:55 GMT

Thank you so much for your help, you are a life saver!