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 g...
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.

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.