Forum Discussion
how to use what if parameters using IF or SWITCH statement
how to use what if parameter using IF or SWITCH statement
what if parameter value is 0 to 100
if statment is:
if (days<=10,"<10",
if (days >10 && days<=20,"10 to 20",
if (days >20 && days<=30,"20 to 30",
if(days >30 && days<=40,"30 to 40", "morethan 40")
I need to use what if parameter value in the palce of <=10, >10 && <20 etc
if (days<=whatifparameter value,"<10",
if (days > whatifparameter value && days<=whatifparameter value,"10 to 20" (this is should like whatifparameter value to whatifparameter value),
if (days >whatifparameter value && days<=whatifparameter value,"20 to 30"this is should like whatifparameter value to whatifparameter value),
if(days >whatifparameter value && days<=whatifparameter value,"30 to 40 (this is should like whatifparameter value to whatifparameter value), "morethan 40")
could you please help me how to use waht if parameter values in IF or SWITCH statements?
1 Reply
Gabriel_WalkmanContinued Contributor
Did you tru googling at all?
Here's some ideas https://community.powerbi.com/t5/Desktop/if-then-else/m-p/117999
Though I'm not sure what you are asking about the whatifparameter. Have a google at dax variables.
In your examples you don't need the > checks at all. It's already covered by the previous if.