Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All
Instead of date drop down slicers, if we choose between as show in image, can we get selected Max & Min dates..?
Ref
Solved! Go to Solution.
Hi @refint650 ,
To get the max and min dates, first check whether the dates in the date slicer are continuously.
min_date = CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))
max_date = CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table'[Date]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @refint650 ,
To get the max and min dates, first check whether the dates in the date slicer are continuously.
min_date = CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))
max_date = CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table'[Date]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |