Bug in the Calculation of Date

[Anonymous]

Dear Power BI team,

Prev Week =

Var CurrenDate = MAX('Date C'[Date])

VAR PrevDate = DATE(YEAR(CurrenDate), MONTH(CurrenDate), DAY(CurrenDate)-7)

Return PrevDate

Since this week the function doesn't work.

I assume the reason is that the current date Date is this month (2020-06-07) and previous week last month (2020-05-31).

Therefore it didn't calculate the previous date, before it was recognized automatically.

Best,

Liudmila

[Anonymous · Accepted solution]

Solved. Now it is just MAX('Date C'[Date]) - 7 😉