Forum Discussion

wilbur750's avatar
wilbur750
Frequent Visitor
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

wilbur750's avatar
wilbur750
Frequent Visitor
2 years ago

Hi

 

Sorry for being daft... what is M code?  Seems you have a mixture of excel and PowerQuery?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Mashup (M for short) is the language of Power Query.

  • wilbur750's avatar
    wilbur750
    Frequent Visitor
    2 years ago

    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.