Forum Discussion

Daretoexplore's avatar
Daretoexplore
Advocate I
2 years ago
Solved

Tricky calculation

Hi all

 

I have a couple of tricky calculations and wondering if you could assist please.

 

My data is roughly as follows:

ID.          Start_Date(UK)         Step

1.           21/6/24.                   Enter store 

1.           22/6/24.                   Get Trolley

1.           25/6/24.                   Enter checkout 

2.           20/6/24.                   Enter store 

2.           24/6/24.                   Get Trolley

2.           28/6/24.                   Enter checkout

 

I'm looking for either a calculated column or DAX measure to calculate the following:

Days between 'Get Trolley' and 'Enter checkout' for each ID

Days between 'Enter store and Enter checkout' for each ID

 

 

Hope that makes sense!

Thank you!

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Daretoexplore 

    pls try to create measure

     

    Measure = DATEDIFF(maxx(FILTER('Table','Table'[Step]="Enter store"),'Table'[Start_Date]),maxx(FILTER('Table','Table'[Step]="Enter checkout"),'Table'[Start_Date]),day)
     
    Measure 2 = DATEDIFF(maxx(FILTER('Table','Table'[Step]="Get Trolley"),'Table'[Start_Date]),maxx(FILTER('Table','Table'[Step]="Enter checkout"),'Table'[Start_Date]),day)
     
     
     

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    Daretoexplore 

    pls try to create measure

     

    Measure = DATEDIFF(maxx(FILTER('Table','Table'[Step]="Enter store"),'Table'[Start_Date]),maxx(FILTER('Table','Table'[Step]="Enter checkout"),'Table'[Start_Date]),day)
     
    Measure 2 = DATEDIFF(maxx(FILTER('Table','Table'[Step]="Get Trolley"),'Table'[Start_Date]),maxx(FILTER('Table','Table'[Step]="Enter checkout"),'Table'[Start_Date]),day)