Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
9 years ago
Solved

Calculating Multiple DateDiffs

I have some table data that shows when an Opportunity enters and leaves the "SE Queue."   I need to calculate total time the Opportunity spends In the SE Queue.   The problem is, the Opportunity ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi bhmiller89,

     

    You can refer to below sample if it help for you.

     

    Table:

     

    Measure:

    Diff =
    var currState= LASTNONBLANK(Sheet4[State],[State])
    Return
    if(currState="leave",DATEDIFF(MAXX(FILTER(ALL(Sheet4),Sheet4[Opportunity ]=MAX(Sheet4[Opportunity ])&&Sheet4[Date]<MAX([Date])),[Date]),MAX([Date]),SECOND),0)


    Notice, If contain multiple "enter" date, it will get the "enter" date which nearliest the "leave" date.

     

    Create visual:

     

    Then you only need to summary the diff of the same opportunity.

     

    If above is not help, please share us some sample data.


    Regards,

    Xiaoxin Sheng

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Can you post some sample data?