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.
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.
I had to convert the values to cm but it doesn't seem to work on all, I am highlight an example where it break the rules
Check =
SWITCH (
TRUE(),
'ITEM_MASTER'[UOM_LENGTH] > 58.42 || 'ITEM_MASTER'[UOM_WIDTH] > 58.42 || 'ITEM_MASTER'[UOM_HEIGHT] > 58.42, "One over 58.42",
('ITEM_MASTER'[UOM_LENGTH] > 35.56 && 'ITEM_MASTER'[UOM_WIDTH] > 35.56) || ('ITEM_MASTER'[UOM_WIDTH] > 35.56 && 'ITEM_MASTER'[UOM_HEIGHT] > 35.56) || ('ITEM_MASTER'[UOM_HEIGHT] > 35.56 && 'ITEM_MASTER'[UOM_LENGTH] > 35.56), "Two over 35.56",
'ITEM_MASTER'[UOM_LENGTH] > 27.94 && 'ITEM_MASTER'[UOM_WIDTH] > 27.94 && 'ITEM_MASTER'[UOM_HEIGHT] > 27.94, "Three over 27.94",
"good"
)
Your check is for a singel value > 58.42 which your hightlighted row is not.
You are correct