Analysis Services

Add KPI (Key Performance Indicator) based on Delivery Days between two Dates to Tabular Project

You have two Dates in your Tabular Project

KPI your two date columns OrderDate and ShipDate

 

 

  1. Create a new calculated column:
    KPI Add/Insert a new column

Give it the name “DeliveryDays“.

2. Enter following formula:

=IF(isblank([OrderDate]);0;IF([ShipDate]<[OrderDate];0;[ShipDate]-[OrderDate]))*1

KPI Enter Formula

 

 

 

3. Go to the measure grid (bottom) and enter a new measure to the previously created column:

Average of DeliveryDays:=AVERAGE([DeliveryDays])

KPI Create Average Measure

KPI Created Average Measure in Measure Grid

 

 

 

 

 

4. Create KPI by right clicking on the newly created Average measure:

KPI Create KPI Right Mouse Click on created measure

 

 

 

 

 

5. A new dialog will pop up and you have to define the KPI details:

Create KPI (Key Performance Indicator) Dialog

 

 

 

 

 

 

After hitting OK you will notice a KPI Indicator Symbol in your measure grid:

KPI Indicator in measure grid after closing Dialog

 

 

6. Analyze the Results in Excel:

KPIs in Excel Pivot Table

 

 

 

 

 

 

This was a quick tutorial of how to create a KPI using a new calculated column in a Tabular Project using SSDT Visual Studio 2013.