Forum Discussion

trailblazer2022's avatar
trailblazer2022
New Member
3 years ago
Solved

Dynamic Baseline for Percentage Difference

Hi, I have the following formula:     Revenue % difference from 1H 2019 = VAR __BASELINE_VALUE = CALCULATE( [Revenue], 'Revenue by Product'[Period] IN { "1H 2019" }, ALL('Revenue b...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi trailblazer2022 ,

     

    You will need a dim table like below:

    column1   column2

    1H 2019    1

    2H 2019    2

    1H 2020    3

    2H 2020    4

    Then use column1 as x-axis and replace { "1H 2019" } to selectedvalue([ column2])+1/-1

     

    Best Regards,

    Jay

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi trailblazer2022 ,

 

You will need a dim table like below:

column1   column2

1H 2019    1

2H 2019    2

1H 2020    3

2H 2020    4

Then use column1 as x-axis and replace { "1H 2019" } to selectedvalue([ column2])+1/-1

 

Best Regards,

Jay