Forum Discussion

froxas's avatar
froxas
Helper II
7 years ago
Solved

Create a table and fill with data every day

Hi,   I have project table with project name, from date, till date and workload per day:     I want to analyze workload per day with column chart. I think that i would need to all the day...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    using Power Query you can add a custom column to your table using this code

    List.Dates(
[From]
,Number.From([Till])-Number.From([From])+1
,#duration(1,0,0,0)
)

    Select the "Expand to new rows" option after selecting the expansion symbol.

     

    The result will look like this:

     

    Hopefully this is what you are looking for.

     

    Regards,

    Tom

     

     

     

     

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

using Power Query you can add a custom column to your table using this code

List.Dates(
[From]
,Number.From([Till])-Number.From([From])+1
,#duration(1,0,0,0)
)

Select the "Expand to new rows" option after selecting the expansion symbol.

 

The result will look like this:

 

Hopefully this is what you are looking for.

 

Regards,

Tom