The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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...
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