Forum Discussion
Helper ILocal 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.
Super UserSagarChauhan1 , You have to create custom calendar for that. can you provide the same in excel of table format.
Helper IHi,
The issue half reolved with this solution. but still my issue is 28 days no Qtr month so not sure how to convert that in formula. Below is the my Organazation month dates. If you can help with MTD and QTD formula.