Forum Discussion
How to create customized calander
KenPuls- There is no fixed pattern of 4-4-5 to the dates. in the prvious financial year it was 5-4-5.
so need some other way around this!!
Anonymous - can you please guide me to any of the steps that you have suggested to get a way around?
If there is no pattern to the dates, then it's going to be pretty difficult to built an M script to lay out the calendar. 5-4-5 we can work with (although that is one I've never heard of... seems a week too long...), but if it's not that this year, then what are the rules? Someone must have decided on what periods go where, so that must have some kind of logic. As long as you can draw out the logical rules, then I'm sure we can build something to handle it.
Failing that, the only method I can see to get around it is to either:
-Build it manually in Excel and call it as a data source, or
-Build it manually in Power BI Desktop using the Home --> Enter Data feature to build a manual table.
Must admit, the latter does not excite me, as it will be tedious to create and even worse to maintain.