Forum Discussion
last date
Bonjour j'ai une table avec 2 colonnes, la première avec des dates de prestations et la deuxième avec des personnes.
Les dates de prestations ne se suivent pas. je souhaiterais obtenir le nombre de jours entre la date de la ligne et la date inférieure existante par personne.
Ex dans le fichier joint, Pour obtenir la colonne Diff Last date à partir de date et Nom
| Date | Nom | Diff last date |
| 01/07/2019 | A | null |
| 02/07/2019 | A | 1 |
| 05/07/2019 | A | 3 |
| 01/07/2019 | B | null |
| 03/07/2019 | B | 2 |
Merci
Hi Anonymous ,
Try this code for a custom column:
Diff =VAR _mindDate = CALCULATE(MIN('Table'[Date]), FILTER('Table', 'Table'[Nom] = EARLIER('Table'[Nom])))RETURN DATEDIFF(_mindDate, 'Table'[Date], DAY)Bonsoir Anonymous
Diff last date = DATEDIFF ( CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[Nom] ), Table1[Date] < EARLIER ( Table1[Date] ) ), Table1[Date], DAY )Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
2 Replies
Bonsoir Anonymous
Diff last date = DATEDIFF ( CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[Nom] ), Table1[Date] < EARLIER ( Table1[Date] ) ), Table1[Date], DAY )Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi Anonymous ,
Try this code for a custom column:
Diff =VAR _mindDate = CALCULATE(MIN('Table'[Date]), FILTER('Table', 'Table'[Nom] = EARLIER('Table'[Nom])))RETURN DATEDIFF(_mindDate, 'Table'[Date], DAY)