Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Bonjour
j'ai une table projet qui contient les colonnes name(nom de projet), start(date de debut), finish(date de fin), pourcentage(pourcentage d'avancement de projet).
J'ai besoin de votre aide svp. Le but est d'écrire une ou plusieurs formules DAX permettant de calculer le retard des projets. Par exemple:
le premier(1) projet est en retard car la date de finition(Finish) c'etait en 2023 et le pourcentage est 5%.
le premier(2) projet est en retard car la date de finition(Finish) c'etait en 2023 et le pourcentage est 90%.
Mais les 10,11 eme projets ne sont pas en retard car leur dates de finition(Finish) c'est en 2024 et leur pourcentages respectifs sont de 0%.
Merci pour votre temps.
Ci-joint un exemple de données:
Solved! Go to Solution.
Hi @CAMARA ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the new column to filter the project.
Status =
VAR DateFinish = TODAY()
RETURN
IF(
AND(YEAR('Table'[Finish]) < YEAR(DateFinish), 'Table'[Percentage] < 1),
"Delayed",
"Non delayed"
)
3.Create the new measure to filter the project delayed.
Delayed project =
VAR statu_ = SELECTEDVALUE('Table'[Status])
RETURN
IF(statu_ = "Delayed", "red", "green")
4.Select Name column and choose conditional formatting.
5.Select Field value style and base on the measure.
6.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CAMARA ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the new column to filter the project.
Status =
VAR DateFinish = TODAY()
RETURN
IF(
AND(YEAR('Table'[Finish]) < YEAR(DateFinish), 'Table'[Percentage] < 1),
"Delayed",
"Non delayed"
)
3.Create the new measure to filter the project delayed.
Delayed project =
VAR statu_ = SELECTEDVALUE('Table'[Status])
RETURN
IF(statu_ = "Delayed", "red", "green")
4.Select Name column and choose conditional formatting.
5.Select Field value style and base on the measure.
6.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
47 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |