Forum Discussion
Local Month End
Hi SagarChauhan1 ,
It sounds like you need to create a 445 calendar. Try this thread:
https://community.powerbi.com/t5/Desktop/Custom-445-Fiscal-Year-Calendar/td-p/161257
Just be mindful that, by his own admission, Matt Allington's technique does not allow for the 53-week years. It also looks like he creates a 454 rather than a 445 calendar, but this should be easy enough to remedy by changing the order of his steps.
Pete
Hi SagarChauhan1 ,
Refer to these:
https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SagarChauhan1 ,
It sounds like you need to create a 445 calendar. Try this thread:
https://community.powerbi.com/t5/Desktop/Custom-445-Fiscal-Year-Calendar/td-p/161257
Just be mindful that, by his own admission, Matt Allington's technique does not allow for the 53-week years. It also looks like he creates a 454 rather than a 445 calendar, but this should be easy enough to remedy by changing the order of his steps.
Pete