topic Re: Create a KPI target based on the previous year value in DAX Commands and Tips

Create a KPI target based on the previous year value

game1 — Fri, 01 Mar 2024 14:24:56 GMT

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

talespin — Wed, 14 Feb 2024 07:07:18 GMT

Please use

Count = COUNT(TestTbl7[items])*1.8

VillyMBI — Wed, 14 Feb 2024 09:42:44 GMT

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 — Fri, 01 Mar 2024 14:20:18 GMT

Working.

Thanks!

VillyMBI — Thu, 15 Feb 2024 08:17:21 GMT

Please find the link Test.pbix

I hope this will help you