Date calculation question

[jerryr125]

Hi - 

In regards to date calculations, is there a way to calculate the past Friday of today's date ?

That is, if today is 02/08/2024, the 'past Friday' was 02/02/2024.

This is, if today is 02/10/2024, the 'past Friday' is 02/09/2024.

Any assistance is appreciated - Jerry

[lbendlin · Accepted solution]

You left out the most important one - what should it be on 2/9/2024 ?

Also, do you want this as DAX or as Power Query?

Past Friday = TODAY()-mod(WEEKDAY(TODAY(),2)+2,7)

or

Past Friday = TODAY()-MAXX(FILTER(ADDCOLUMNS(GENERATESERIES(0,7),"WD",WEEKDAY(TODAY()-[Value],2)),[WD]=5),[Value])