How to create a KPI wich shows the same period of the last year with this year

[emiliosjlc]

Hello,

I have a table with this data,

DATE     VALUE

1/1/16  36

2/2/16 20

...

1/1/17 67

2/1/17 45

I want create a KPI wich compare the same period of the last year with this year., that is, indicator: Value, Trend:Date and target value: Last year value.

Thank you very much.

Best regards

[v-shex-msft · Accepted solution]

Hi @emiliosjlc,

Current power bi not support to create kpi, you should create it in powerpivot then import the workbook into power bi.

Reference:

Create a KPI in Power Pivot for Excel: Overview

In addition, you can use below formula to get the same period of last year value:

SP LY = CALCULATE(SUM('Fact'[Amount]),SAMEPERIODLASTYEAR('Calendar'[Date]))

Notice: calendar table has the relationship to fact table.

Regards,

Xiaoxin Sheng

[dilumd]

if you can give a sample data set with expected coloums in excel we can look in to it.

[emiliosjlc]

Yes, of course. This is my data...to 2015 until 06/30/2017