Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter date in Calculate function

Hello,   I am posting because I am pretty new on Power BI and I seem to be stuck on a particular issue I hope you could help me with.   The problem is the following :   I have a list of number,...
Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

If you want to make a measure Total Amt = SUM(Data[Vlue])

Then you can do:

Last Month := CALCULATE([Total Amt], PREVIOUSMONTH('Dates'[Date]))    or

Last Month =  CALCULATE(SUM(Data[Value]), PREVIOUSMONTH('Dates'[Date])) 

 

This should be OK for you.