Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Icon for Helper V rankHelper V
3 years ago

datesbetween different by row

Hello,   I'm looking for a way to calculate a difference between two values. so far so good. Différence Kms CBu vs Capte = CALCULATE( [Somme Kms Electric Final CB]-[Somme Kms Electric Final]...
Need Help
GeekAlfPro's avatar
GeekAlfPro
Icon for Helper V rankHelper V
3 years ago

Maybe i'm not accurate enough.

here is a table with different use cases

 

VehicleDate[Somme Kms Electric Final CB]Date[Somme Kms Electric Final]result
101/09/20221200024/01/2023750null
207/10/20221550007/10/20221545050
301/09/20222375601/09/2023210002756
415/12/2022782324/01/20233254null

 

 

Actually, to make it easier to understand if dates of different tables are equals, so i need the result.

 

Thanks