Forum Discussion
Help with Calendar
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 ?
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.
2 Replies
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-Power-BI-Turning/ba-p/1187482Hi 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.
