Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm looking for ways to get data for PREVIOUSMONTH if we select multiple months. I just need the data for the previous month of the max selected date. If we select Jan till June, i want the sales data for May, which is the same if I select June only.
I've tried CALCULATE([SalesSum],FILTER(CalendarTable, DATEADD(CalendarTable[Date], -1,MONTH))) but it doesn't work. Appreciate any help here.
Thanks !
Solved! Go to Solution.
Hi, @Velvetine27
You can try the following methods.
Sample data:
Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Month]=MAX('Table'[Month])-1))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Velvetine27
You can try the following methods.
Sample data:
Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Month]=MAX('Table'[Month])-1))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MaxSelectedDate = MAX('Table'[Date])
PreviousMonthSales = CALCULATE( SUM('Table'[Sales]),
DATEADD('Table'[Date], -1, MONTH) = [MaxSelectedDate] )
Hi, there's an error to this dax, "A function 'DATEADD' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
TRY this once,
MaxSelectedDate = MAX('Table'[Date])
PreviousMonthSales = CALCULATE( SUM('Table'[Sales]),
DATESINPERIOD('Table[Date],MaxSelectedDate, -1,Month))
User | Count |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |