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?
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 )
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?
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.
Incidents today: 4
Incidents yesterday: 2
with this shown on the KPI as an increase in the number of incidents.
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)
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.