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.
Hello. I have some data in power BI representing tasks.
Task | Start date | End date | Progress |
Get data | 1.1.2023 | 31.5.2023 | 25% |
Create visuals | 1.3.2023 | 31.6.2023 | 0% |
The idea is to split each year into 3 parts and make a gantt chart for the tasks. However, if a task spans multiple parts it must be split into different task for each part. The progress must also be calculated seperatly for each part the task is in. Any ideas how this might be done with DAX?
Thanks in advance.
Not enough sample data to work with. You would also need to assume linear progress over time. That's not what happens in real life.
Lets say each period id 4 months, so period one ends in april. A task may start in january and finish in june so the goal is to split it into two tasks, one that spans period 1 and another that is from may to june. So only one data point should be fine. But I guess one could ask the project managers to do this manually as its not a lot of work.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |