Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
8 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
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")

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    AlexGallet01,


    Please help to post sample data of the TECHNIKE table.

    Regards,
    Lydia Zhang

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        AlexGallet01,

        I haven't seen the TEST NON VIDE column from the table you post. Could you please post complete columns with sample data that can be copied and pasted so  that I can test?

        Regards,
        Lydia