Create a table and fill with data every day

[froxas]

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 days with workloads, to transform it to following table:

How could i atchieve it ? Generation new table?

[Ashish_Mathur]

Hi,

Write this Custom column formula in the Query Editor

{Number.From([From])..Number.From([Till])}

Hope this helps.

[TomMartens · Accepted solution]

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