Tricky calculation

[Daretoexplore]

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!

[ryan_mayu · Accepted solution]

@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)

[Daretoexplore]

That is amazing!

Thank you so much...kudos given.

[ryan_mayu]

you are welcome