cancel
Showing results for
Did you mean:
Helper I

## KPI showing incidents today vs yesterday, week and month

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

8 REPLIES 8
Microsoft

@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

Frequent Visitor

Thank you, that's exactly what I needed.

Helper I

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?

Super User IV

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

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

---------------------------------------

@ me in replies or I'll lose your thread!!!

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helper I

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.

Super User IV

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)```

---------------------------------------

@ me in replies or I'll lose your thread!!!

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helper I

That worked perfectly. Thank you!

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

Microsoft

@CraigC

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

Best Regards,
Herbert

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Claim Your Badge & Digital Swag!

Check out how to claim yours today!

#### Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors