Forum Discussion

Nihed's avatar
Nihed
Helper III
4 years ago

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) ...
VahidDM's avatar
VahidDM
Super User
4 years ago

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's avatar
Nihed
Helper III
4 years ago

 

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's avatar
    V-lianl-msft
    Community Support
    4 years ago

    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.