KPI goal last period

[Alejandro_bi]

How to create a KPI where the objective is the income of the previous year or the previous month or last period? Using Dax

Thanks!

[Anonymous]

Have you tried this?

https://msdn.microsoft.com/en-us/library/ee634972.aspx

[Alejandro_bi]

Yes, I create this measure; 

Goal Honorario Total = CALCULATE(SUM(Actividad[Honorario Total]);SAMEPERIODLASTYEAR(Actividad[Fecha Actuacion].[Date]))

But the objective always appears as empty or infinity.

[v-sihou-msft · Accepted solution]

@Anonymous

If you want to calculate the total of Previous Month or Previous Year, you can directly use PREVIOUSMONTH() or PREVIOUSYEAR() function, and directly use the Date column instead of [column].[Date]. 

If you want to specify multiple periods date range, you can also use DATESINPERIOD().

Regards,