Forum Discussion
How to delete all dates except Previous week date
Hello Everyone,
I have two date fields in my table such as Date 1 & Date 2. But for one Date 2, I want to delete all the dates except the Previous week's date (from the Previous week's Sunday to the Previous week's Saturday). If I add Date 2 to the slicer, it should show dates between the Previous week's Sunday and the Previous week's Saturday. How can I achieve this?
The main requirement is that. I have created this Table.
VAR DateFilter = DATATABLE("Date Filter", STRING,
{
{"Last Week"},
{"Multi Year"}
}
)
RETURN
DateFilter
If the Selection is "Last week" on Slicer then It should use Date 2 in the Date Slicer and If the selection is "Multi Year" then it should use Date 1 in the Date slicer.
How can I achieve this?
1 Reply
Hello ajitsahoo8338,
Can you please try this approach:
Previous_Week_Filter = VAR LastSunday = MAXX( FILTER( ALL('YourTable'), 'YourTable'[Date 2] <= TODAY() - WEEKDAY(TODAY(), 1) ), 'YourTable'[Date 2] ) - 6 VAR LastSaturday = LastSunday + 6 RETURN IF( SELECTEDVALUE('DateFilter'[Date Filter]) = "Last Week", IF( MAX('YourTable'[Date 2]) >= LastSunday && MAX('YourTable'[Date 2]) <= LastSaturday, 1, 0 ), 1 )
