Forum Discussion

EDO_01_1789's avatar
EDO_01_1789
Helper I
4 years ago
Solved

Previous date dax or M

Hello  yes I would like your help about a probleme I have put below a table of what I want : Fichier Excel Validator Name Validation date Previous validator date  Excel File  A Valid...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, EDO_01_1789 ;

    You could create a measure by dax.

     

    Measure = 
CALCULATE(MAX('Table'[Validation date]),
FILTER(ALL('Table'),[Fichier Excel]=MAX('Table'[Fichier Excel])&&[Validation date]<MAX('Table'[Validation date])))

     

    the final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, EDO_01_1789 ;

You could create a measure by dax.

 

Measure = 
CALCULATE(MAX('Table'[Validation date]),
FILTER(ALL('Table'),[Fichier Excel]=MAX('Table'[Fichier Excel])&&[Validation date]<MAX('Table'[Validation date])))

 

the final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.