Forum Discussion

Elirot's avatar
Elirot
Frequent Visitor
7 years ago

Time difference based on two key columns

Hi guys,   I'm strugelling to get the duration in seconds between the minimum CompletedDate and maximum CompletedDate of the same AccountAppId and Team. If you look at the follwoing image of the d...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Elirot

 

It seems a measure is better than calculated column for your data. Here is the file for your reference.

Group2 =
SUMX (
    FILTER ( ALL ( table2 ), Table2[Index] <= MAX ( Table2[Index] ) ),
    Table2[Sort]
)

Regards,

Cherie

Elirot's avatar
Elirot
Frequent Visitor
7 years ago

Hi Cherie,

 

Well, I've tried with the measure as well, but unfortunately got an error message - lack of resources (see image), even if I filter it down only to the current year.

 

Thanks

 

Eli

 

 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Elirot

     

    I've forgot your data is large. I would appreciated it if you could share your sample file which could reproduce your scenario.

     

    Regards,

    Cherie

  • Elirot's avatar
    Elirot
    Frequent Visitor
    7 years ago

    Hi Cherie,

     

    Sorry it took me so long but business prioirities are always in place... :smileyhappy:

     

    Please find the link to the data file.

     

    Regards,

     

    Eli

     

    Data file