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.
Month | Issue |
Jan | Resolved |
Jan | Open |
Jan | Open |
Feb | Resolved |
Feb | Resolved |
Feb | Resolved |
Feb | Resolved |
Hi all, I am keen to show a card that will show as "100% Resolved with a Thumbs Up" whereby The Thumbs up is a condition that compares against data from Feb & Jan. I had used the below (but it requires me to manually change the values and change filters...
@mdjoshua94 , which measure you are not able to calculate here ??
@amitchandak , I am unable to measure based on months. My current measure uses a fixed value. I intend to compare the current month and the previous month.
@mdjoshua94 , if you have dates you can use time intelligence and date table to get this month vs last month
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
Another way is to use rank. But for that, you need Asc rank on month
This month = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[month Rank]=max('Date'[month Rank])))
Last month = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[month Rank]=max('Date'[month Rank])-1))
It can be a date or month table . prefer a separate table for time
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
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 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |