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 All,
I have created a date table and have used the following to create a KPI for today vs Yesterday:
Today KPI : Ticket_Close_KPI_Today = CALCULATE(COUNT(Tickets[Ticket Close DaysAgo]);Tickets[Ticket Close DaysAgo]=0)
Yesterday KPI : Ticket_Close_KPI_Yesterday = CALCULATE(COUNT(Tickets[Ticket Close DaysAgo]);Tickets[Ticket Close DaysAgo]=1)
How would i translate that into this week vs last week as well as this month vs last month?
Thank you
Ticket_Close_KPI_Today = CALCULATE(COUNT(Tickets[Ticket Close DaysAgo]);Tickets[Ticket Close DaysAgo]=0)
Could you please share us some sample data of you date table? So that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.
Regards,
Charlie Liao
Hi Please find link to file. It is the Tickets Table that you see.
Let me know if that helps at all?
Any feedback?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |