Forum Discussion

amir_mm's avatar
amir_mm
Icon for Helper III rankHelper III
2 years ago
Solved

Between date slicer - default start and end time

Hi, I’m using a between date slicer and have applied the measure "CurrentDay = 'Dim-Date'[Date] - TODAY()" with a page-level filter set to "less than or equal to 0" so that the default end date is a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi amir_mm ,

     

    You can try below formula to create calculated column and use it to page filter.

    CurrentDay = 
VAR StartDate = TODAY() - 7
RETURN
    IF('Dim-Date'[Date] >= StartDate && 'Dim-Date'[Date] <= TODAY(), 1, 0)

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
2 years ago

Good Question, I'm having the same issue , so commenting to get this post to the top