KPI showing incidents today vs yesterday, week and month

[CraigC]

Hi All,

I would like to create a KPI indicator showing incidents created today vs yesterday. Currently i have no date table but i do have a create date cloumn. How would i go about creating this KPI?

Thank you

[v-haibl-msft]

@CraigC

Assuming that we have a Date column and an Incident Count column. We can create two calculated measures as below.

Inc_Today = 
CALCULATE ( SUM ( Table1[Incident_Count] ), Table1[Date] = TODAY () )

Inc_Yesterday = 
CALCULATE ( SUM ( Table1[Incident_Count] ), Table1[Date] = TODAY () - 1 )

Best Regards,
Herbert

[ashlibek]

Thank you, that's exactly what I needed.

[CraigC]

Hi unfortunately i dont have a count of incidents column. I simply have an open date and a close date and neither of them are linked to a date table. I can link them to a date table but then how would i create the KPI measure for today vs yesterday?

[Greg_Deckler]

Many times you do this by using a DATEDIFF coupled with TODAY in a column, such as:

DaysAgo = DATEDIFF([Date],TODAY(),DAY)

[CraigC]

Wouldnt this just count the days between the date and today? Im trying to calculate the number of incidents for today vs the number of incidents for yesterday on a KPI.

So effectively 

Incidents today: 4

Incidents yesterday: 2

with this shown on the KPI as an increase in the number of incidents.

[Greg_Deckler]

OK, the concept was to create that column and then you could create measures for you KPI's:

KPI_Today = CALCULATE(COUNT(<column>),[DaysAgo]=0)

KPI_Yesterday = CALCULATE(COUNT(<column>),[DaysAgo]=1)

[CraigC]

That worked perfectly. Thank you!

How would i then translate that to this week vs last week and this month vs last month?

[v-haibl-msft]

@CraigC

You can create a week column and a month column, then using the similar DAX formula to do it.

Best Regards,
Herbert