Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Dynamic Year Over Year Percent Change

hi all   I need to calculate a year over year percent change of tickets created based on the year I select with a slicer.    E.g. if I choose 2018 from the slicer, it should compare the 2018 vs 2...
Need Help
Show and Tell
  • mwegener's avatar
    mwegener
    6 years ago

    Hi o59393 ,

     

    You may download my PBIX file from here.
    Hope this helps.

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi o59393 

 

try this.

 

Change % = 
IF (
    HASONEVALUE ( report1576508921493[Year] );
    DIVIDE (
        [Number of Tickets];
        CALCULATE (
            [Number of Tickets];
            FILTER (
                ALL ( report1576508921493[Year] );
                report1576508921493[Year]
                    = MAX ( report1576508921493[Year] ) - 1
            )
        )
    )-1;
    BLANK()
)

 

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

o59393's avatar
o59393
Post Prodigy
6 years ago

You rock, thanks a million for your help!!

 

Have a great day!