KPI based on previous

[game1]

I want to calculate with a DAX formula the Target of my KPI based on the filter of the date of the same month, but of the previous year and multiply by 2. FOR EXAMPLE, if I have in January 2020 count a total number of 100 for YourTable[date] as the number of rows (i.e. count the total number of rows of the YourTable[date] column corresponding to the period January 2020), then my Target for January 2021 should return 200.
If I have in 2020-01-01, 1000 as the number of rows of YourTable[date], then this should return me 2000 for 2021-01-01, as my Target. So, each time, my Target must take into account the number of rows for the same period and multiply it by 2. I use a Slicer to filter my dates. So, if I just select 2019 as the year and it returns 10000 as the number of rows, then my target should return 20000.

[ValtteriN]

Hi,

Here is how to do this:

data:

Relationship:

DAX:

target =

CALCULATE(MAX('Table (15)'[Value]),DATEADD('Calendar'[Date],-1,YEAR))*2

Now in the visual I am using 'Calendar'[Date] and target measure:
When a single date is selected the value changes accordingly.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[game1]

This one work only if i select the same day, month, year ? FOR EXAMPLE, if I have in January 2020 count a total number of 100 for YourTable[date] as the number of rows (i.e. count the total number of rows of the YourTable[date] column corresponding to the period January 2020), then my Target for January 2021 should return 200.  It should then only consider only the total of the same month and year.

[Anonymous]

Hi @game1 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng