Forum Discussion

BlastS's avatar
BlastS
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:   Index TIME ColumnF Duration ColumnX 1 30/07/2012 00:0...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    See if this helps:

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

BlastS's avatar
BlastS
Helper I
7 years ago

HI, Anonymous

Like each 10 of duration its 10 min so the output after sum all should be like 0 00:50:00 (means 0 days 0 hours 50 min 0 sec)

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi BlastS,

 

Here is a blog for your reference, please refer to it to convert minutes to duration.

Aggregating Duration/Time

 

Best regards,

Yuliana Gu