Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CraigC
Helper I
Helper I

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
v-caliao-msft
Microsoft Employee
Microsoft Employee

@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

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?

Any feedback?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.