cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CraigC Regular Visitor
Regular Visitor

This Week vs Last Week KPI

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

3 REPLIES 3
Highlighted
Moderator v-caliao-msft
Moderator

Re: This Week vs Last Week KPI

@CraigC,

 

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? S
o 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

CraigC Regular Visitor
Regular Visitor

Re: This Week vs Last Week KPI

Hi Please find link to file. It is the Tickets Table that you see.

https://multiequipment062-my.sharepoint.com/personal/craig_multi_co_za/_layouts/15/guestaccess.aspx?...

 

Let me know if that helps at all?

CraigC Regular Visitor
Regular Visitor

Re: This Week vs Last Week KPI

Any feedback?

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,155)