Date Formula to Adjust Date by any number of days, weeks or months

[derektdb]

I am looking for a way to have a custom column look at one data set of dates and adjust it by one day. So if the date is 2/19/2018, I would like the output to be 1 less the day, so 2/18/2018. In excel you could just do this by subtracting 1 in the formula. How can you do this in Power BI?

[MFelix · Accepted solution]

Hi @derektdb,

Just do it exactly as Excel, add a column with the following formula:

minus date = Dates_fact[Date] - 1

Regards,

MFelix

[derektdb]

I see my flaw! I was doing this in the Query Editor rather than from the Data tab. Thank you!