Forum Discussion

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

KPI based on previous

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...
"DAX"
KPI
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
game1
Icon for Helper III rankHelper III
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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