Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All, need help in calcualting value based on multiple conditions mentioned below ... Please advice
1> If "Cell Number" <> "NA", then
2> If "Pages" is >= "Min Pages", then
3> If "Cell" is = A, then
4> If "PEH" is <=8,"Q"*0.25,If "PEH" is <=10,"Q"*0.50,If "PEH" is <=12,"Q"*0.75,If "PEH" is <=14,"Q"*1.0, else
5> If "Cell" is = B, then
6> If "PEH" is <=8,"Q"*0.20,If "PEH" is <=10,"Q"*0.40,If "PEH" is <=12,"Q"*0.65,If "PEH" is <=14,"Q"*1.0, else
7> If "Cell" is = C, then
8> If "PEH" is <=10,"Q"*0.40,If "PEH" is <=12,"Q"*0.60,If "PEH" is <=14,"Q"*0.85,If "PEH" is <=16,"Q"*1.0,
9> else "Q"
10> else "0"
Solved! Go to Solution.
@Navin_C If it worked for you then please mark that as an accepted solution so that other users can find it more easily.
Thank You!
@Navin_C You can write a DAX formula like this:
value
=IF([Cell Number]<>"NA",
IF([Pages]>=[Min Pages],
SWITCH([Cell],
"A", SWITCH(TRUE(),
[PEH]<=8,"Q"*0.25,
[PEH]<=10,"Q"*0.50,
[PEH]<=12,"Q"*0.75,
[PEH]<=14,"Q"*1.0,
"Q"
),
"B", SWITCH(TRUE(),
[PEH]<=8,"Q"*0.20,
[PEH]<=10,"Q"*0.40,
[PEH]<=12,"Q"*0.65,
[PEH]<=14,"Q"*1.0,
"Q"
),
"C", SWITCH(TRUE(),
[PEH]<=10,"Q"*0.40,
[PEH]<=12,"Q"*0.60,
[PEH]<=14,"Q"*0.85,
[PEH]<=16,"Q"*1.0,
"Q"
),
"Q"
),
"0"
),
"0"
)
If you find this insightful, please provide a Kudo and accept this as a solution.
Thanks Devesh
@Navin_C If it worked for you then please mark that as an accepted solution so that other users can find it more easily.
Thank You!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
12 | |
12 | |
9 |
User | Count |
---|---|
63 | |
21 | |
21 | |
17 | |
11 |