Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to 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 🙂
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |