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)

Thank you.

3 Replies

  • 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.