how to use what if parameters using IF or SWITCH statement

[Anonymous]

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?

[Gabriel_Walkman]

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.