Forum Discussion
Solved
How to create a calendar table with multiple rows per date
Hi How do I create a calendar table where there are multiple rows for each date? I have 15 council recycling collection rounds that collect from residents every week day. I am ultimately needin...
wilbur750 You're welcome. You could also simply go in to the Query Editor, right-click within the Queries pane, then select New Query, then Blank Query. Once done, select Query1, open the Advanced Editor on the Home tab then paste the code I sent yesterday over the existing code.
Mashup (M for short) is the language of Power Query.
Sorry havent used tables from excel like this before, just Excel sheets. I have recreated your tables I think and called them Start, End and RecRds in Excel. I have loaded the 3 tables into PBI and Im now in PQ. So do I do 'new data > blank query' then copy/paste your code? I'm a bit confused. Cant find any of the tables or the sheet name.