Forum Discussion
Sum to specific date and dynamic filter
Hi all, I am still a beginner and relatively new to Power BI. I have been trying for a while to solve the following scenario. I want to calculate a sum of sales so that, when the report is opened, ...
By default, the value 3,623 should be displayed in this case (for 01.08.2024).
When the month filter and year filter, or only the month for example, July (2024), are applied, the result 5,184.51 should be shown in the card visual.
When only the year is filtered to 2025, the result should be 13,011.81 in this example.
I hope this makes it clearer.
Thank you very much!