Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
Can you provide some prints of the table whit wrong results?
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |