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.
Hi All,
I want to create a measure that calculates Sales from the start of available data in my table till the last date I have selected.
I am currently using the following formula but the issue is it's affected by the slicer or filter min date selected is there any way to bypass this
"
Hi thanks for your help but i got the solution using formula below
@AbdulSaboor987 , for an easy solution, you can try to disable the interaction between the slicer and your visual.
Hi,
if i do that i wont be able to select max date
In this case, you may create a calculated table whose column is the exact value of your available date (using DAX), or if you prefer, you can do it in PowerQuery.
Leave that calculated table / new PowerQuery Table without any relationship to your data.
Then, use that column of your calculated table in your slicer, and change the definition of MaxSelectedDate in your measure.
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |