Forum Discussion
Solved
Multiple conditions to check
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...
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!
devesh_gupta
Impactful Individual
Impactful IndividualNavin_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
- devesh_gupta
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!