List of dates for previous week in time using intelligent time slicer
Hello - I'm trying to make a table with values in a column called "Selection" for MTD, YTD, PYTD, PMTD, and WEEKLY. I'm using the concept for intelligent time slicers linked here: (https://youtu.be/AdLDYohLeJc). I'm currently hung up on trying to generate the "Weekly" Selection. I can generate the dates properly for WTD using: VAR WeekStart = CALCULATE( TodayDate-WEEKDAY(TodayDate,3), FILTER( DISTINCT('Dates'[Date]), YEAR('Dates'[date]) =YEAR(TodayDate) ) ) and then: ADDCOLUMNS( CALENDAR(WeekStart, TodayDate), "Selection", "Weekly", "Sort", 6)) However, the data I would like to filter on this specific request is trailing by 3 weeks. How would I obtain a list of dates using the calendar function for a week of dates that is 3 weeks back? Ex. if the date is 8/22/22, I would like the list of days for the week of 8/1/22-through 8/7/22. I have the extended date table available with week offsets, but I can't figure out how to use dax to get the dates I would like to display. Thanks!
