Forum Discussion
How to create customized calander
Your intuitions here are correct. You need to somehow get a thorough calendar table built and imported. Could be that calendar comes from a csv file, a database table, or writing Power Query / M to generate it... a bunch of options, but as it's custom there is no "out of box" solution for you.
KenPuls probably has a post on generate custom calendar in M if I had to guess. ImkeF you know of one?
Helper III've probably got an example somewhere, yes. Is this just a 4-4-5 calendar, or is there some other pattern to the dates?
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?
- KenPuls
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.