I have been working with a litle of dax function but still i am strunglig to get this exact thing which is: I have as columns: IndexTIMEColumnFDurationColumnX130/07/2012 00:01:10 230/07/2012 00:01:200100330/07/2012 00:01:300100430/07/2012 00:01:400100.2530/07/2012 00:01:500100.2630/07/2012 00:02:000100.2730/08/2012 00:02:101100830/07/2012 00:02:200100930/07/2012 00:02:300100.21030/07/2012 00:02:400100.21130/07/2012 00:02:5011001230/07/2012 00:03:000100 The Output Should be = 50 (30 + 20) in format like dd:HH:mm:SS ( 00 00:50:00) What i want to do is to sum all the time duration when columnX is 0.2 (how can i sum each individually ) ? How can i achieve this on powerbi ?

Helper I

7 years ago

Solved

Calculate/SumAll Duration in specific intervals

I have been working with a litle of dax function but still i am strunglig to get this exact thing which is:

I have as columns:

The Output Should be = 50 (30 + 20) in format like dd:HH:mm:SS ( 00 00:50:00)

What i want to do is to sum all the time duration when columnX is 0.2 (how can i sum each individually ) ?

How can i achieve this on powerbi ?

Anonymous

See if this helps:

Measure = 
CALCULATE(
    SUM(Table1[Duration]),
    Table1[ColumnX]=.20
)