Forum Discussion

BlastS's avatar
BlastS
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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?