Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
9 years ago
Solved

Power Query assistance

Hi everyone,   I am trying to create a table in Power Query based off of another table in Power Query. The new table needs to have a row of data for every date that occurs between start and finish ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    GilesWalker,

    Based on my test, the error is due to the large amount in your table. If I filter the table to keep top 210000 rows, everything works well, if I filter the table to keep top 220000 rows, the error occurs. Consider to reduce the rows in your table.



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

GilesWalker,

You can convert the date columns from Date/Time type to Date type, then apply the M code that Excelside provides.


Regards,
Lydia

GilesWalker's avatar
GilesWalker
Skilled Sharer
9 years ago

Anonymous thanks for the reply. Unfortonately I require the query to be done at thet minute level after further review of the data. For example:

 

Date from           Date to               Length     Weight

1/1/17 12:01       1/1/17 12:03      123           15

 

New table:

Date                    Length     Weight

1/1/17 12:01       123           15

1/1/17 12:02       123           15

1/1/17 12:03       123           15