Need help DAX

[Nihed]

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)

Thank you.

[VahidDM]

Hi @Nihed 

It'd be better if you share a sample of your data to know the column name and data type.

BTW, you need to use a dax like this:

IF(MAX('PPM'[Step])="9-Finalised",SUM(each STEP DURATION from TORs to Signature))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Nihed]

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

[V-lianl-msft]

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.