Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Percent difference calculation using different values

Hi there!

 

I am looking for some help with my dax:

I have a very simplified dataset and I want to calculate the percent difference (V2-V1)/V1 . I would like a way to calculate the percent difference based off of different reference values: AVGstatic, AVGmonthly (calculated). I would only like to have 1 column called 'Percent difference' , but I don't know how to filter the table properly. 

 

Thank you for your help.

 

Corey

 

OUTPUT: 

 

AVGstatic = 6

 

TABLE 1:

DateBananas EatenPercent difference
1.1.202460
1.2.2024717%
1.3.2024833%

 

AVGMonthly = 10

TABLE 1:

DateBananas EatenPercent difference
1.1.20246-40%
1.2.20247-30%
1.3.20248-20%
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    You can try dax like below:

     

    M1 =
VAR cur =
    IF (
        NOT ISBLANK ( SELECTEDVALUE ( slice[tag] ) ),
        SELECTEDVALUE ( slice[value] ),
        BLANK ()
    )
RETURN
    ( MAX ( 'Table'[Bananas Eaten] ) - cur ) / cur

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    You can try dax like below:

     

    M1 =
VAR cur =
    IF (
        NOT ISBLANK ( SELECTEDVALUE ( slice[tag] ) ),
        SELECTEDVALUE ( slice[value] ),
        BLANK ()
    )
RETURN
    ( MAX ( 'Table'[Bananas Eaten] ) - cur ) / cur

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly