Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey all,
I'm trying to do a custom column to see what items will fit into my standard size box. Here is my DAX -
Solved! Go to Solution.
This is because you're returning a blank when it doesn't satisfy the first 3 conditions.
You can add those cases back in like this:
Box Fit =
IF (
'Items'[UNIT_HEIGHT (CM)] < 5,
IF (
'Items'[UNIT_LENGTH(CM)] < 23,
IF (
'Items'[UNIT_WIDTH (CM)] < 20,
IF ( 'Items'[UNIT_WEIGHT (KG)] < 1, "FIT", "NO FIT" ),
"NO FIT"
),
"NO FIT"
),
"NO FIT"
)
or simplify to this:
Box Fit =
IF (
'Items'[UNIT_HEIGHT (CM)] < 5
&& 'Items'[UNIT_LENGTH(CM)] < 23
&& 'Items'[UNIT_WIDTH (CM)] < 20
&& 'Items'[UNIT_WEIGHT (KG)] < 1,
"FIT",
"NO FIT"
)
This is because you're returning a blank when it doesn't satisfy the first 3 conditions.
You can add those cases back in like this:
Box Fit =
IF (
'Items'[UNIT_HEIGHT (CM)] < 5,
IF (
'Items'[UNIT_LENGTH(CM)] < 23,
IF (
'Items'[UNIT_WIDTH (CM)] < 20,
IF ( 'Items'[UNIT_WEIGHT (KG)] < 1, "FIT", "NO FIT" ),
"NO FIT"
),
"NO FIT"
),
"NO FIT"
)
or simplify to this:
Box Fit =
IF (
'Items'[UNIT_HEIGHT (CM)] < 5
&& 'Items'[UNIT_LENGTH(CM)] < 23
&& 'Items'[UNIT_WIDTH (CM)] < 20
&& 'Items'[UNIT_WEIGHT (KG)] < 1,
"FIT",
"NO FIT"
)
Thank you so much! I had tried with just an "and" between them but it looks like it needed two of them. Works perfectly now!
Yep. A single "&" is used for concatenating text and "&&" is the logical operator.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |