Show Previous Months from One Month Selected in Power BI

If you need to select single month but show several previous months, or from the beginning of the year in your charts, watch this video.
We often face this kind of requirements in real BI projects.
This video will help you boost your DAX.
In this video, we will see the following DAX functions:
DATESINPERIOD
REMOVEFILTERS
KEEPFILTERS
Master Calendar in Power BI and SSAS:
• Calendar in Power BI, ...
BI Land :
/ biland

[@henkelssarah913]

Really great explanation, thanks a lot for sharing!

[@BILand]

Thanks for watching :)

[@garyrowe58]

EXACTLY what I was looking for, and what's more, very clearly explained! Thank you so much!

[@BILand]

Happy it was helpful :)

[@phollihn]

Great video I like your approach. How can you do this but for fiscal year?

[@ZzZzZiggy]

I cannot make it work and it's driving me CRAZY. The only difference in my case is that I am using two slicers: one for Year, the other for Month Name. And it's showing me only the single month selected? Any ideas? 😔

[@BILand]

I see. I would suggest using date in the filter, otherwise this formula won't work. The fact of using month in slicer or year makes it as category, it would need eventually different approach and formula

[@garyrowe58]

aarghh - but: how does it work in a Many to One relationship, when the data is one to one? And setting it to 'Many to One' makes my orginal calendar table (built with CalandarAuto) lose its data!!!!

[@BILand]

Thanks for your comment, in this solution the relationship between two calendars should be uni directional. However the pseudo calendar should not affect the other calendar

[@teomss]

Nice video man. Thank you.

[@BILand]

You're welcome. Thanks for your comment:)