Forum Discussion

LucasMascarellD's avatar
LucasMascarellD
Frequent Visitor
3 years ago

Schedule, Gantt

Hi, I need some Help, I use Excel to create a schedule, like a Gantt Chart, Imagen:     I use this formula to calculate de cells :  =SE(MÍNIMO($AB$1-SOMA(AD$8:AD19),$Z20-SOMA($AB20:AC20)...
"DAX"
Gantt chart
schedule
PiEye's avatar
PiEye
Icon for Resolver II rankResolver II
3 years ago

Hi Lucas,

 

I think we're going to need more information. While the excel formula is helpful, I can't see the column references for the cells.

Can you tell me

  • What does the raw data look like? (or provide)
  • What is the calculation achieving & why, very broadly.

While the detail calculation itself is useful (min / max sum etc) there is a much wider range of expressions in DAX and the resulting steps may be different and more optimal than just trying to replicate every part of an excel expression.

 

PS Intendo portugues 🙂

 

Pi

LucasMascarellD's avatar
LucasMascarellD
Frequent Visitor
3 years ago

I´m sorry, I rewrote the text, I thing it´s clearer now.

I showing the expression that I use on Excel, because it was the way that a found to resolve.