Forum Discussion

refint650's avatar
refint650
Helper 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.

     

     

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Community 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.