Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |