topic Re: Tricky calculation in DAX Commands and Tips

Tricky calculation

Daretoexplore — Mon, 24 Jun 2024 09:17:44 GMT

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!

Re: Tricky calculation

ryan_mayu — Mon, 24 Jun 2024 09:37:22 GMT

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)

Re: Tricky calculation

Daretoexplore — Mon, 24 Jun 2024 10:14:45 GMT

That is amazing!

Thank you so much...kudos given.

Re: Tricky calculation

ryan_mayu — Tue, 25 Jun 2024 01:14:02 GMT

you are welcome