Forum Discussion
Create Query with a range of dates from table
Hi, I have an Excel table in the following format that I need to manipulate in Power Query.
| UserID | From Date | To Date | Utilisation Rate |
| U124566 | 02/07/2022 | 14/07/2022 | 50% |
| P678900 | 31/05/2022 | 30/06/2022 | 10% |
Is it possible to generate something as follows so that I get a series of dates, between the from and to date by user with the application Utilisation Rate ?
| UserID | Date | Utilisation Rate |
| U124566 | 02/07/2022 | 50% |
| U124566 | 03/07/2022 | 50% |
| U124566 | 04/07/2022 | 50% |
Would appreciate any help or advice
Thanks and regards
M
Hi Anonymous ,
Try this as a new custom column:
List.Transform( { Number.From([Date From])..Number.From([Date To]) }, each Date.From(_) )Expand the resulting nested-list column.
Pete
