Conditional Filter

[Anonymous]

Hello, 

I have to create a fiancial report which be refreshed everyday. In this report, I would like make a comparaision between the sales of this year and and other year (which would have been chose by the companie with a filter "2019, 2020, 2021").

My issue is that 2022 is not finished, there are some months which don't have any data because it's on the future. So, for example I would to compare the first five months of 2022 with the first five months of 2021, but if I make that, the comparaision won't be good because 2021 has seven months more than 2022. 

I understand that the companie could put the filter manually, but our goal is to make the report refreshing automatically, so when we will be on June, the filter will take June and the comparaison between months will be good. 

Sorry if it's not understable, I can't give more information because it's private Data ...

Thank you very much in advance ! 

[SpartaBI · Accepted solution]

You can definitely achieve it. It's the way it should be. The best thing you can do is to learn from the ground up and from the best (SQLBI.com).
Learn these patterns:
https://www.daxpatterns.com/time-patterns/

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂