Previous Week Ending

[Nagin]

Hi,

I am trying to calculate the previous weekending based on the curent max weekending, however the result only returns the max weekending date (04/02/24). With the dax query below my current max weekending date is 04/02/24 and would like it to return 28/01/24. I also have week number in this table and have tried referencing this.

CAT 2 Max Week =

var max_week = MAXX(ALL('Daily CAT 2'),'Daily CAT 2'[Week Ending])

var previous_week = CALCULATE(max_week,'Daily CAT 2'[Week Ending]-1)

RETURN

previous_week

Regards

Nagin

[some_bih · Accepted solution]

Hi @Nagin try with DAX function WEEKNUM. With Return type part you should control what is start / end of your week as day.

Check link for example