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

Anonymous's avatar
Anonymous
Not applicable
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

VladSorokin's avatar
VladSorokin
New Member
3 years ago

Thanks a lot, Gao, this works!!!