Forum Discussion

Frequent Visitor

8 years ago

Solved

DAX Calculating Status Duration and Averages

Hi, I am looking for some input on calculating status duration and averages. We have a table that takes a snapshot of each serial no. daily and what status it is in. Currently 50 million + rows. ...

Need Help

Zubair_Muhammad
8 years ago
Hi RDA_PowerBI

It works for me both in Excel and Power BI desktop

I am attaching both files.

DAX Calculating Status Duration and Averages.pbix41 KB

RDA_PowerBI

Frequent Visitor

8 years ago

Hi Zubair,

Thank you for your reply. I tried the calculated column but was unsuccesful:

Zubair_Muhammad

Community Champion

8 years ago

Hi RDA_PowerBI

It works for me both in Excel and Power BI desktop

I am attaching both files.

DAX Calculating Status Duration and Averages.pbix41 KB

Zubair_Muhammad
Community Champion
8 years ago
Heres the Excel file. See the Power Pivot Model
DAX Calculating Status Duration and Averages.xlsx235 KB

Forum Discussion

DAX Calculating Status Duration and Averages

Related content

Calculate Average Duration Time (mm:ss)

Calculate Average Duration in hh:mm:ss

Durations - Dynamic Formats or Calculation Groups? Or both?

Calculating Weighted Average

DAX Measure for Ranking the valid rows and calculating the average rating