Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to get the previous month's NAME of a selected date to appear on a card but, I always get an error when I use this:
Solved! Go to Solution.
@Xandman , Try like
calculate(FORMAT(max(DateTable[Date]),"MMMM"),PREVIOUSMONTH(DateTable[Date]))
Try like
SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(DateTable[Date]))
2nd SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(dateadd(DateTable[Date],-1,month)))
last MTD = CALCULATE([Total Subs],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
@Xandman , Try like
calculate(FORMAT(max(DateTable[Date]),"MMMM"),PREVIOUSMONTH(DateTable[Date]))
Try like
SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(DateTable[Date]))
2nd SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(dateadd(DateTable[Date],-1,month)))
last MTD = CALCULATE([Total Subs],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
Thank you! I used the same pattern to get the names too.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |