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 ,

 

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.

  • o59393's avatar
    o59393
    Post Prodigy
    6 years ago

    WOW!

     

    Looks very solid. Just one thing, how can I get the result as 45.87% instead of 145.87%?

     

    I tried swtiching the numerator and denominator but didnt work.

     

    Change % =
    IF (
    HASONEVALUE ( report1576508921493[Year] ),
    DIVIDE (
    [Number of Tickets],
    CALCULATE (
    [Number of Tickets],
    FILTER (
    ALL ( report1576508921493[Year] ),
    report1576508921493[Year]
    = MAX ( report1576508921493[Year] ) - 1
    )
    ),
    BLANK ()
    )
    )
     
    Thanks a mill!!!

     

     

    • 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!