Forum Discussion

Nagin's avatar
Nagin
Frequent Visitor
2 years ago
Solved

Previous Week Ending

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's avatar
    some_bih
    2 years ago

    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

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    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