Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
Hi,
Write this Custom column formula in the Query Editor
{Number.From([From])..Number.From([Till])}
Hope this helps.
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