Forum Discussion
Reduce data by adding new column
Your check is for a singel value > 58.42 which your hightlighted row is not.
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.
That works for adding to the Model which is good, Aside point do you know if it is possible to add to the query editor?
Thanks for all the help
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.