Year Number Calculation

[ub2811]

Hello there,

I have caluclated a week number starting from Saturday which works fine. But when new year starts it starts adding from 1 again.

I want to calculate week number in such a way thet at the end of year it shouldn;t starting from 1 but conitnue counting like 53 53 55 56 to the end of date. I have years of data.

[amitchandak]

@ub2811 , Take the min week start from Saturday and calculate from that.

Min Week St = min([Week Start Date])

Week Number = Quotient(Datediff([Min Week St],[date],day),7) +1

You can also refer for Saturday week

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

[ub2811]

It worked for week, thanks.

I want to do same for the month as well. How can we do that, keepin min dthat a month can have variable days