Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |