Forum Discussion

refint650's avatar
refint650
Icon for Helper III rankHelper III
5 years ago
Solved

calendar filter

Hello All Instead of date drop down slicers, if we choose between as show in image, can we get selected Max & Min dates..? Ref
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

     

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.