Forum Discussion
Helper IICreate 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 days with workloads, to transform it to following table:
How could i atchieve it ? Generation new table?
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
2 Replies
- TomMartens
Super User
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
- Ashish_Mathur
Hi,
Write this Custom column formula in the Query Editor
{Number.From([From])..Number.From([Till])}
Hope this helps.
