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))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks! I would like to avoid entering the exact day as this will change when i refresh my data source. Using my measurement in lieu of the '92' in your formula seemed to work. Thanks very much 🙂