Help with Calendar

[em0840]

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 ?

[Anonymous · Accepted 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.

[amitchandak]

@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...