Forum Discussion
Stharwani
Advocate II
Advocate IIDax: convert monthly data to weeks
Hi team, I am using this formula to show week number Weeks = ROUNDDOWN(('Date'[Date] - 'Date'[StartOfFY]+2)/7,0)+1 When I try to show it along with months on a bar chart, the shared week app...
StharwaniAdvocate II
Advocate IIAny ideas ImkeF MattAllington
Thanks.
MattAllington
Community Champion
Community ChampionMy advice is to create a proper calendar table.
Read my article here https://exceleratorbi.com.au/power-pivot-calendar-tables/
and my blog here https://powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/