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 community,
I'm trying to build a GANTT view in my Power BI Report using tasks durations and prerequisites. I need to calculate the starting date of an operation according to the end date of its prerequisites (that is not usually unique). You can find below the content of my table:
I set up a starting date of the first task to 1 september using the DAX code :
Please refer to the picture above:
Operation1 doesn't have any prerequisite so it should take the starting date of the project that I've introduced as a measure.
Operation 2 has one prerequisite (which is operation 1) should start at the end of operation 1. It ends at end of operation 1 +duration of operation 2
Same thing for operation 3 it follows operation 2 so it shoul start at the end date of operation 2 and it will finish 3 days after because the execution of operation takes 21 hours (8 working hours a day)
....
operation 11 has two prerequisites 9 and 10, so its starting date will be the max finish date of 9 and 10.
@Anonymous Well, you can do emulated FOR and WHILE loops in DAX.
https://community.powerbi.com/t5/Quick-Measures-Gallery/For-Loop/m-p/637531#M319
https://community.powerbi.com/t5/Quick-Measures-Gallery/While-Loop/m-p/637535#M320
Recursion or previous value is very difficult
However, I'm not sure exactly what you want. Can you post sample data as text and expected output?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |