Forum Discussion
Responsive ResidentCumulative 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.
Responsive ResidentThanks fahadqadir3,
I have problems seeign your dasboard. I cannot see anything.
I want to show the average by days x phase so I can provide timelines graphs like the one below:
The idea is to:
SUM (Av signature vs Greenlight) + SUM (Av GreenL vs Sales handover)........ it shows a trend of total days by phase.
x
Solution Supplierromovaro 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.
- romovaro
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?
Phase1_Days - Contract2Green =CALCULATE(AVERAGEX(FY24,DATEDIFF(FY24[Contrat Signature date], FY24[Greenlight Date], DAY)),FY24[Contrat Signature date] >= DATE(2023, 7, 1) && FY24[Contrat Signature date] < DATE(2024, 6, 30))Thanks
- fahadqadir3
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.