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.
How to get the same period YTDs across any previous years in a single formula.
ie. across a Matrix like this, i want the June YTDs across all years :
Solved! Go to Solution.
I inserted it in the answer below.
It was this:
***************************************************
Hello @Antmkjr how are you?
would it be like this?
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
can you share the formula
I inserted it in the answer below.
It was this:
***************************************************
Would you mind attaching the pbix as well?
No I only want June YTD for all the years, ie. 2022 june YTD, 2021 June YTD,2020 June YTD etc in a single formula
I didn't understand the application very well.
This result can be obtained from the filter.
Could you contextualize the objective?
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
Yes , but every month it should calculate automatically, so for next month it should calculate YTD August across all years, and then Sept YTD across all years so on.
See if this is it:
***************************************************
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
Could you pls attach the pbix?
Of course, here's the link: https://easyupload.io/z0udod
This is my test file.
These are fictitious data.
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |