Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating Measurement between fixed Date and calculated Date

'm interested in creating a report comparing a before and after of two equivalent time periods.   The after period is looking at the days from a fixed date (1/10/20) to the most recent case in the ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You can create measure like this and try

    Rolling -92 = CALCULATE(countrows(date_table),DATESINPERIOD('Date'[Date ],date(2020,10,01),-92,Day))


    Rolling 92 = CALCULATE(countrows(date_table),DATESINPERIOD('Date'[Date ],date(2020,10,01),92,Day))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

datesinperiod(date_table[Date_field].[Date],date(2020,10,1),-92,DAY)