This Week vs Last Week KPI

[CraigC]

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

[v-caliao-msft]

@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? 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

[CraigC]

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]

Any feedback?