Start week Date since Saturday.

[eshanpacheriwal]

Tryign to do a basic week start date from staurday and end at friday. 

I was using this but its not giving the right result.
Any suggestions? 

Start of week saturday to friday = [Date] - WEEKDAY([Date],2) -1

[v-jianboli-msft · Accepted solution]

Hi @eshanpacheriwal ,

Please try:

Start of week saturday to friday =

var _a = WEEKDAY([Date],2)

return IF(_a<=5,[Date]-_a-1,[Date]-_a+6)

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcalheir]

Can you provide some prints of the table whit wrong results?