Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi,
I have some data grouped into weekly bins (every 7 days) which is working great but I noticed the first day of each 7 day bin is a Sunday. Please can you tell me how to change this to a Monday?
Thanks,
CM
Solved! Go to Solution.
Hi @CloudMonkey
You may create a calculated column like this post.
Column = VAR d = MAX( Table2[date] ) RETURN d - QUOTIENT ( DATEDIFF ( Table2[Date], d, DAY ), 7 ) * 7
Regards,
Hi @CloudMonkey
You may create a calculated column like this post.
Column = VAR d = MAX( Table2[date] ) RETURN d - QUOTIENT ( DATEDIFF ( Table2[Date], d, DAY ), 7 ) * 7
Regards,
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |