Forum Discussion
Need help DAX
Hello, How I can convert this formula into dax please : IF 'PPM'[Step] = "9-Finalised" then STEP DURATION = SUM(each STEP DURATION from TORs to Signature) (what is the correct syntax for each) ...
Bonjour
Je partage avec vous le lien de mon exemple dans pbix : https://we.tl/t-PjRN81lAWA
et mon but est de calculer le KPI dans le tableau ci-dessous (DURÉE DE L’ÉTAPE) à partir des deux tableaux quelqu’un m’a aidé un peu sur ce sujet s’il vous plaît
Hi Nihed ,
It's hard to understand the calculation logic of "8-xxx"&"9-xxx". In the sample pbix you provided, I can't create the corresponding calculation.
Measure =
var current_step = MAX(PPM[Steps])
return
SWITCH(TRUE(),
current_step = "1 - Planned/Not Started",0,
current_step="2 - TORs received/under review",AVERAGEX(PPM,PPM[TORs completed]-PPM[TORs received]),
current_step="3 - Open for Competition",
AVERAGEX(PPM,PPM[Closes on]-PPM[Posted on]),
current_step="4 - Technical Evaluations",
AVERAGEX(PPM,PPM[Technical evaluation completed]-PPM[Closes on]),
current_step = "5 - Financial Negotiations",
AVERAGEX(PPM,PPM[Negotiation completed]-PPM[Technical evaluation completed]),
current_step="6 - Procurement Board",
AVERAGEX(PPM,PPM[PB date]-PPM[Negotiation completed]),
current_step = "7 - Legal Review",
AVERAGEX(PPM,PPM[Reviewed by LEG]-PPM[PB date]),
current_step="8 - Signature",
AVERAGEX(
))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.