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

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

Calculating Weighted Average

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

Calculating average 12 month average