Hi,
New to power query need to do the above. So add a column which is the result of that statement and then filter the query on new custom column.
This is the working formula in excel table:
Wish to filter on value 1.
Basically this query highlights an inv keying error, we sell some prods out in kgs others each ("ea"). For prods we sell in kgs this query is a control to highlight when we have a kg qty which is not a multiple of its weight, then its a keying error or weve accidentally keyed kg value for product which is sold out as Each (e.g. complete unit) but customer would twig that as the inv value would be huge
.
Pretty sure I can do it in power query by creating 2 separate custom columns (orange and green) then wrote my if refs these 2 columns. But wish to know how to use with Truncate.
I'm fine applying the filter but second question is it necessarily for me to create a custom column to then filter or can I save this as an expression etc (no not correct term) in background and filter on it?
Many Thanks
New to power query need to do the above. So add a column which is the result of that statement and then filter the query on new custom column.
This is the working formula in excel table:
Wish to filter on value 1.
Basically this query highlights an inv keying error, we sell some prods out in kgs others each ("ea"). For prods we sell in kgs this query is a control to highlight when we have a kg qty which is not a multiple of its weight, then its a keying error or weve accidentally keyed kg value for product which is sold out as Each (e.g. complete unit) but customer would twig that as the inv value would be huge
.Pretty sure I can do it in power query by creating 2 separate custom columns (orange and green) then wrote my if refs these 2 columns. But wish to know how to use with Truncate.
I'm fine applying the filter but second question is it necessarily for me to create a custom column to then filter or can I save this as an expression etc (no not correct term) in background and filter on it?
Many Thanks
