cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Till
Resolver II
Resolver II

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 from 2019.
and from February 2020 the rate from 2019.
How do I get only 2020 and 2021 displayed for January and February?

Screenshot 2021-04-17 055919.png

Measure:

f_05_revenue_actual_month_2020_mdt =
CALCULATE (
SUM ( 'sql_revenue'[value] ),
'sql_revenue'[type_1] = "ACTUAL",
'sql_revenue'[type_2] = "revenue",
'sql_revenue'[ver_desc] = 1,
SAMEPERIODLASTYEAR(tbl_calendar[Date])
)

Thanks for help.


 

Kind regards

1 ACCEPTED SOLUTION
Gabriel_Walkman
Responsive Resident
Responsive Resident

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?

View solution in original post

3 REPLIES 3
Gabriel_Walkman
Responsive Resident
Responsive Resident

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?

View solution in original post

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
Community Support
Community Support

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.

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors