Previous Week Ending

Nagin — Thu, 08 Feb 2024 09:48:10 GMT

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

Re: Previous Week Ending

some_bih — Thu, 08 Feb 2024 14:01:06 GMT

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

topic Re: Previous Week Ending in DAX Commands and Tips

Previous Week Ending

Re: Previous Week Ending