Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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])
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])
I did it like this but it doesn’t work 😕
@Nihed provide some more details then; e.g. sample data and expected output
This KPI is displayed in the following table:
I must calculate the AMOUNT field
The metric is defined below:
KPI | Source | Filters | Source fields | Rules |
Amount | PPM tab | Type = “CFT” | Cumulated Contract Amount Estimated Amount | 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] |
@Nihed please provide sample data in table format
@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])
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |