Forum Discussion

dnsia's avatar
dnsia
Helper II
5 years ago
Solved

How to calculate date diff between two rows and columns

Hi all,  Please help.    BL No Container No Load  Discharge  DCHF   TRFF RCVF SSTR SNTC   RCVE BL0001 CONT0001 PORT A PORT D 6/1/2020 4:12   6/1/2020 10:50       ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    5 years ago

    dnsia 

    Here are the two columns that you need to add:

    Dim = 
var __bilno = [BL No] 
var __sntc = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[SNTC])
var __dchf = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[DCHF])
return
   IF( Table11[SNTC] <> BLANK() , DATEDIFF( __dchf, __sntc , DAY ) )
    Det = 
var __bilno = [BL No] 
var __rcve = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[SNTC])
var __dchf = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[RCVE])
return
   IF( Table11[RCVE] <> BLANK() , DATEDIFF( __rcve, __dchf , DAY ) )

     

     



Fowmy's avatar
Fowmy
Super User
5 years ago

dnsia 

Here are the two columns that you need to add:

Dim = 
var __bilno = [BL No] 
var __sntc = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[SNTC])
var __dchf = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[DCHF])
return
   IF( Table11[SNTC] <> BLANK() , DATEDIFF( __dchf, __sntc , DAY ) )
Det = 
var __bilno = [BL No] 
var __rcve = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[SNTC])
var __dchf = 
    MAXX( FILTER( table11 , Table11[BL No] = __bilno ) , Table11[RCVE])
return
   IF( Table11[RCVE] <> BLANK() , DATEDIFF( __rcve, __dchf , DAY ) )

 

 



  • dnsia's avatar
    dnsia
    Helper II
    5 years ago

    This is working fine! Thank you so much for your help!