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
)

Anonymous's avatar
Anonymous
Not applicable
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

 

That helps a litle but its not that i am exactly looking for. After that how you would convert to datetime?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Sorry, dont follow.  Could you possibly put what your expected output would be?

    • 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