Forum Discussion
Date diff
Hello, I want to do a date diff between datemoyenne of my colum valeursutilisé = B and datemoyenne of my colum valeursutilisé = A. I need do it for each valeursutilisé.
AlexGallet01,
You may need to create a calculated table containing ValeusrUtilise, DateMoyenne and other fields, then create calculted column using the DAX I provide.
If you have any questions about creating calculated table, please share raw data of your table and post the DAX you use to create the above measures.
Regards,
Lydia
Hello,
As far as values are concerned, they are the values of a column of my table but for the date it is a measure.
DateMoyenne = FORMAT(average(TECHNIKE[TEST NON VIDE]);"YYYY-MM-DD")