Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a 2 Year data which is daywise . I would like to present it weekwise but my week dont start From Monday , I want it start from Saturday and end on Friday . What is the easiest way ?
Solved! Go to Solution.
Hi @em0840 ,
You can add three calculated columns to realise.
The first column is to get the date of Saturday.
Saturday = IF(WEEKDAY([Date],2)=6,[Date])
The second columns is to fill down the date.
FillDown = CALCULATE(LASTNONBLANK('Table'[Saturday],1),FILTER('Table',[Date]<=EARLIER('Table'[Date])))
The third column is to rank by the dates. And the result is the week numbers.
WeekNum = RANKX('Table',[FillDown],,ASC,Dense)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @em0840 ,
You can add three calculated columns to realise.
The first column is to get the date of Saturday.
Saturday = IF(WEEKDAY([Date],2)=6,[Date])
The second columns is to fill down the date.
FillDown = CALCULATE(LASTNONBLANK('Table'[Saturday],1),FILTER('Table',[Date]<=EARLIER('Table'[Date])))
The third column is to rank by the dates. And the result is the week numbers.
WeekNum = RANKX('Table',[FillDown],,ASC,Dense)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@em0840 , Create a calendar and create a week starting from Saturday using my blog
Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |