Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have 3 measures as follows:-
How can I also display the the previous month total based on the slicer selection for each customer?
Solved! Go to Solution.
@smithshire Try this below DAX Measure:
MEASURE = CALCULATE([Overall], DATEADD(TableName[DateColumn],-1,MONTH))
That worked exactly as I wanted is to, many thanks.
@smithshire You are most welcome! Happy to help you.
@smithshire Try this below DAX Measure:
MEASURE = CALCULATE([Overall], DATEADD(TableName[DateColumn],-1,MONTH))
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |