Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi , I have a data set where I have 100 row for the month July 2020 and 0 rows for Aug 2020.
I wrote DAX using TOTALMTD thinking it would show 0 as dont have any rows for Aug 2020 but it is showing 100.
I also wrote PreviousMonth measure and it is showing me 0
@dimsandfacts You may find this useful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Weather Intelligence the Hard Way provides a different way to achieve what you're looking for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Hi,
Create a calendar table and build a relationship from the CreationDate column of the Logs table to the Date column of the Calendar Table. In the Calendar Table, write calculated column formulas to extract Year and Month. Create slicers for Year and Month columns from the Calendar Table. Select year as 2020 and Month as August. Write these measures:
FTM = Count('Logs'[.id])
Previous month = calculate([ftm],previousmonth(calendar[date]))
Hope this helps.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |