Forum Discussion

alsolok's avatar
alsolok
Icon for Helper II rankHelper II
5 years ago
Solved

Visual comparaison

Hello everyone,

Description : this visual represent the trend the "rate growth 2020" color blue and "rate growth  2019" color red.

I'm trying show this visual but my problem is my KPI "rate growth " is global (not year particular). 

Do I have to calculate the 2020 growth rate from the overall growth rate? and the same for 2019 ?? Or should I represent the overall growth rate using the date hierarchy (year -> month).

 

THK

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    alsolok 

    You can calculate 2020 growth  as Growth-2020 = [your measure]
    Your formula for 2019 growht would be = CALCULATE( [Growth-2020 ], SAMPERIODLASTYEAR(Dates[Date]))

    Hope you have a dates table in your model.

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    alsolok 

    You can calculate 2020 growth  as Growth-2020 = [your measure]
    Your formula for 2019 growht would be = CALCULATE( [Growth-2020 ], SAMPERIODLASTYEAR(Dates[Date]))

    Hope you have a dates table in your model.