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.

Nobuddy123's avatar
Nobuddy123
New Member
1 year ago

Hi amir_mm  I am currently facing the same scenario. If you have already found a solution, could you kindly share it with me so I can resolve this issue as well?