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!