Create a KPI target based on the previous year value

[game1]

Hello,

I want a target that shoud multiply the number of items of the previous year or month with 1.8.

So, for example, I have 4 items in 2022. To calculate my Target for 2023, it must be -> Target = 4 * 1.8

Thanks!

 items date

 car     2022/06/19 

 table  2023/10/11 

 chair  2022/10/11 

 table  2022/06/11 

 car     2022/06/13 

 house 2023/02/11 

[VillyMBI]

Hi @game1 ,

I assume you also have date table having relation with your data table

Pre Year Items = CALCULATE(COUNT('Table'[Item]),SAMEPERIODLASTYEAR('DateTable'[Date])) * 1.8

[game1]

Working. 

Thanks! 

[VillyMBI · Accepted solution]

Please find the link Test.pbix

I hope this will help you 

[talespin]

hi @game1 

Please use 

Count = COUNT(TestTbl7[items])*1.8