Forum Discussion

VladSorokin's avatar
VladSorokin
New Member
3 years ago
Solved

Create a table based on another table using formula

Hi, I'm very new to PowerQuery but have a task that makes me mad. Imagine I have a table that possesses 3 columns: "Start Date", "End Date", and "Name". Say, this table contains information about s...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi VladSorokin ,

     

    Please follow the steps below:

    in power quert editor --> add a custom column:

    List.Transform({Number.From([Start Date])..Number.From([End Date])},each Date.From(_))

    expand [Date] and remove [Start Date] and [End Date]:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

I won't give you the full answer but you can represent dates as numbers and then if you create a list using

{[start]..[end]} you can expand that 'to rows' and convert back to dates.

There are examples on the forum or on the web.