Make the graph show current week and previous 3 full weeks

[rpinxt]

So what we want to see is 4 columns with the corresponding weeks.

But when I set a relative date like :

You see it takes also 6th of September but this leads to:

5 weeks in which week 36 is only 1 day. That will confuse people so we do not want that.

Then I was thinking calendar weeks :

But then we get no days in October and its october 3rd now.

So now I have 4 weeks but not the current week 40.

Does somebody know how you can get the current week and the 3 previous full calendar weeks??

[v-tianyich-msft]

Hi @rpinxt ,

This is great, thanks for sharing!

Best regards,
Community Support Team_ Scott Chang

[rpinxt · Accepted solution]

Well I now did it with this filter :

WeekFilter =

VAR MaxWeek = CALCULATE(MAX(dimDate[Week Nr (ISO)]),REMOVEFILTERS(dimDate[Week Nr (ISO)]))

RETURN

IF(SELECTEDVALUE(dimDate[Week Nr (ISO)]) >= MaxWeek - 3,1,0)

Seems to work fine.

But maybe there are better and more elegant solutions?