Define last week from [date]

Solution 1:

You could try something like:

weekMax = 
VAR lastweek = FORMAT(DATEADD('Table'[Date].[Date], -7, DAY) ,"WW YYYY")

RETURN
IF(FORMAT(TODAY() - 7 ,"WW YYYY") = lastweek, lastweek, BLANK())

Output:

enter image description here


Or if you always just want the last week without considering any columns, you can use:

weekMax = FORMAT(TODAY() - 7 ,"WW YYYY")