Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Anonymous ,
Try this code for a custom column:
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
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