Forum Discussion
Solved
Date calculation question
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
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])
1 Reply
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])