cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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?