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.        ...
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)
     
     
     
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)
 
 
 
Daretoexplore's avatar
Daretoexplore
Advocate I
2 years ago

That is amazing!

 

Thank you so much...kudos given.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    you are welcome