Forum Discussion

game1's avatar
game1
Icon for Helper III rankHelper III
2 years ago
Solved

Create a KPI target based on the previous year value

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 

4 Replies

  • VillyMBI's avatar
    VillyMBI
    Icon for Resolver I rankResolver I
    2 years ago

    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