Forum Discussion
Cumulative timeline using average days from differents phases
No need to create relationship between tables.
Power BI file attached, In case you're not able to open this workbook, you need to use latest version of Power BI desktop to use this workbook.
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
romovaro You first need to create a new table like this:
Then create a following measure
Cummulative Line = SWITCH(MAX('COLUMNS'[NAME]),
"Sign vs GL",[AVG Signature vs GL],
"GL vs Sales HO",[AVG Green Light vs Sales HO]+[AVG Signature vs GL],
"Sales HO vs 1stEngangeCall",
[AVG Green Light vs Sales HO]+[AVG Signature vs GL]+[AVG SalesHO vs 1st Engangement Call])
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
HI fahadqadir3
That's what I need.
Created a table and also the measure like you said.
but my table comes blank.
Did you use diff Phase formula? Tables need to be connected?
Can you share pbix just in case?
Thanks
No need to create relationship between tables.
Power BI file attached, In case you're not able to open this workbook, you need to use latest version of Power BI desktop to use this workbook.
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.