Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I am trying to create a week column (displaying week number) which starts from Tuesday and ends next Tuesday.
Any suggestion?
I used Weeknum 21 but it starts from Mon, not Tue.
Thanks a lot
Solved! Go to Solution.
Hi @snamhoang
Please add this calculated column to your Calendar table
Week Starting Tuesday = var offset = switch(FORMAT('Dates'[Date],"DDD"), "Tue",0, "Wed",-1, "thu",-2, "Fri",-3, "Sat",-4, "Sun",-5, "Mon",-6 ,0) Return DATEADD('Dates'[Date],offset,DAY)
Hi @snamhoang
Please add this calculated column to your Calendar table
Week Starting Tuesday = var offset = switch(FORMAT('Dates'[Date],"DDD"), "Tue",0, "Wed",-1, "thu",-2, "Fri",-3, "Sat",-4, "Sun",-5, "Mon",-6 ,0) Return DATEADD('Dates'[Date],offset,DAY)
Hi @snamhoang,
What I would do is to suggest creating a new column in the Query Editor.
In doing that you can easily create it in your Date table, and from there you could then create your weeks also based off your Week Number column?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |