Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago
Solved

Rule with dax

Hello,

 

How do i apply this rule in dax please

IF 'PPM'[Steps] in {"Open for competition","Technical Evaluation Stage","Financial Evaluation Stage","Procurement Board","Legal Review","Contract Signature",""} then AMOUNT = 'PPM'[Estimated Amount]

IF 'PPM'[Steps] = "Process Finalized"  then AMOUNT = 'PPM'[Cumulated Contract Amount]

Thank you

  • Nihed  I believe you are looking for this, pbix is attached

     

    Column 2 =
    IF (
        PPM[Process Steps]
            IN {
            "Open for Competition",
            "Technical Evaluations",
            "Financial Negotiations",
            "Procurement Board",
            "Legal Review",
            "Signature",
            ""
        },
        PPM[Estimated Amount],
        IF ( PPM[Process Steps] IN { "Finalised" }, PPM[Cumulated Contract Amount] )
    )
    

     

    else

    Column = SWITCH(TRUE(),
                    CONTAINSSTRING(PPM[Steps],"Open for competition")=TRUE()||
                    CONTAINSSTRING(PPM[Steps],"Technical Evaluation Stage")=TRUE() ||
                    CONTAINSSTRING(PPM[Steps],"Financial Evaluation Stage")=TRUE() ||
                    CONTAINSSTRING(PPM[Steps],"Procurement Board")=TRUE() ||
                    CONTAINSSTRING(PPM[Steps],"Legal Review")=TRUE() ||
                    CONTAINSSTRING(PPM[Steps],"Contract Signature")=TRUE() , PPM[Estimated Amount],
                    CONTAINSSTRING(PPM[Steps],"Process Finalized")=TRUE(), PPM[Cumulated Contract Amount])

     

7 Replies

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion

    Nihed 

    switch(true(), 
         'PPM'[Steps] in {"Open for competition","Technical Evaluation Stage","Financial Evaluation Stage","Procurement Board","Legal Review","Contract Signature",""} 
    	 ,'PPM'[Estimated Amount]
    	 'PPM'[Steps] = "Process Finalized", 'PPM'[Cumulated Contract Amount])
    • Nihed's avatar
      Nihed
      Icon for Helper III rankHelper III

      I did it like this but it doesn’t work 😕

       

      • smpa01's avatar
        smpa01
        Icon for Community Champion rankCommunity Champion

        Nihed  provide some more details then; e.g. sample data and expected output