Forum Discussion
Dax: 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...
Any ideas ImkeF MattAllington
Thanks.
My 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/