Filtering

[WJ876400]

Hi

I have a report with a start data and then a column with the date difference to the current date. I then want a column that that shows any dates that are within 42 days of the start date and the other cells that are ove this are blank

Start Date	Days Since Start Date
01/01/2023	11
01/01/2022
28/12/2022	15

any help is appreciated

thanks

[Ashish_Mathur]

Hi,

Write this calculated column formula

=if(Data[Start date]>42,blank(),today()-Data[Start date])

Hope this helps.

[Ashish_Mathur]

Hi,

Write this calculated column formula

=if(Data[Start date]>42,blank(),today()-Data[Start date])

Hope this helps.

[Anonymous · Accepted solution]

Hi @WJ876400,

It sounds like a common multiple date range analysis requirements, I'd like to suggest you take a look at the Greg’s blog 'start date', 'end date' parts or add the end date and create a expand table with detail records to mapping with raw table records.

Before You Post, Read This 

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng