Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |