Forum Discussion
Date filter that include 3 previous days
How can I set a date filter that will include the previous 3 days? Example: I need to run a report Monday through Friday, each day the report will contain items added on the previous calendar day, b...
Greg_Deckler
Community Champion
Community ChampionAnonymous Sounds like you need a Complex Selector or perhaps something like:
Measure =
VAR __MaxDate = MAX('Dates'[Date])
VAR __MinDate = __MaxDate - 3
VAR __Table = FILTER( ALL('Table'), [Date] >= __MinDate && [Date] <= __MaxDate )
VAR __Result = SUMX( __Table, [Value] )
RETURN
__Result