Forum Discussion
Solved
Problem with assigning / visualizing FTE distributed amounts to months
Dear community I have a requirement to distribute and visualize the FTE demand over a timeline. The basis is an Excel File which contains only start and end dates, a role, a phase and total hours...
Not exactly sure where your issue is but here is how I would show the data
fte ass = var d = max('Calendar'[Date]) var a = filter(SUMMARIZE(Assignments,[Start Date],[End Date],[FTE]),d in CALENDAR([Start Date],[End Date])) return sumx(a,[FTE])Or like this with a modified ribbon chart
Not exactly sure where your issue is but here is how I would show the data
fte ass =
var d = max('Calendar'[Date])
var a = filter(SUMMARIZE(Assignments,[Start Date],[End Date],[FTE]),d in CALENDAR([Start Date],[End Date]))
return sumx(a,[FTE])
Or like this with a modified ribbon chart
Thank you so much for your solution! This is exactly what I was looking for and I wouldn't be able to develop this myself with my limited skills. Also thank you for the hint to the ribbon chart, it makes much more sense to use this visual.
I tried to recreate the ribbon to look it your way - what exaclty you modified to achieve this?
Again, thank you very very much for your support.