Forum Discussion

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Cumulative timeline using average days from differents phases

Hello   I have a question regarding creating a cumulative timeline. I have a table with different phases and dates     I can create graphs using datediff to see the average of Days betwee...
Need Help
  • fahadqadir3's avatar
    fahadqadir3
    2 years ago

    PBI.pbix 

    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's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
2 years ago

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's avatar
fahadqadir3
Icon for Solution Supplier rankSolution Supplier
2 years ago

PBI.pbix 

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.