Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |