Forum Discussion
Reduce data by adding new column
I'm trying to reduce the amount of data to meet the following requirement Can’t have one dimension greater than 23 inches, or 2 dimensions greater than 14 inches, or 3 dimensions greater than 11 ...
Your check is for a singel value > 58.42 which your hightlighted row is not.
Is your table named 'Table'? If not then you have to change my measure to match the name of the table in your model.
Or you can take the table reference out of the formula:
Check =
SWITCH (
TRUE(),
[UOM_LENGTH] > 23 || [UOM_WIDTH] > 23 || [UOM_HEIGHT] > 23, "One over 23",
([UOM_LENGTH] > 14 && [UOM_WIDTH] > 14) || ([UOM_WIDTH] > 14 && [UOM_HEIGHT] > 14) || ([UOM_HEIGHT] > 14 && [UOM_LENGTH] > 14), "Two over 14",
[UOM_LENGTH] > 11 && [UOM_WIDTH] > 11 && [UOM_HEIGHT] > 11, "Three over 11",
"good"
)I changed the name but I still get an error, see my screenshot
You need to take the
'Check ='
out of your fomula. That is what is causing it to not work.
I removed that and still error, not sure what is causing the error everything else should be swapped correct with my names
Oh, you are trying to add the column in the query editor which uses a different language (M). My formula is for adding the column to the model using DAX in the table view.