Forum Discussion

Till's avatar
Till
Resolver II
5 years ago
Solved

Growth rate

I have a calendar from 01/01/2018 until today. I want to compare the Groth rate for this year with last year from my table Revenue. Now unfortunately it also shows me the Groth rate in January 2020...
Need Help
  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    5 years ago

    Hi.

    SAMEPERIODLASTYEAR does what is says. If you filter your calendar table to show only 2021, the graph should display results for 2020 and 2021.

    Your measure name indicates you want a value spesifically for the year 2020? That sounds a bit like bad practice. What happens when next year comes?

Gabriel_Walkman's avatar
Gabriel_Walkman
Continued Contributor
5 years ago

Hi.

SAMEPERIODLASTYEAR does what is says. If you filter your calendar table to show only 2021, the graph should display results for 2020 and 2021.

Your measure name indicates you want a value spesifically for the year 2020? That sounds a bit like bad practice. What happens when next year comes?

Till's avatar
Till
Resolver II
5 years ago

Hi,

 

thank`s for your reply.
this helps me already once.
I will think about the dynamic at the turn of the year again.
Kind Regards


  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Till ,

     

    Is this problem sloved?
    If not, please let me know.

    Do you want to achieve that by slicers or filters?

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.