Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
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.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |