Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

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é.
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

AlexGallet01,

Where do you store the sample data  you post? Do you want to calculate date difference in Power BI Desktop?

Regards,
Lydia

  • AlexGallet01's avatar
    AlexGallet01
    Helper IV
    9 years ago

    The data that I have published are measurements and yes it is on power bi desktop

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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

      • AlexGallet01's avatar
        AlexGallet01
        Helper IV
        8 years ago

        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")