Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |