I'm just getting into Power Query and I'm having trouble with the following.
I have a line of code;
At the moment this just checks one column [Net Billings (exc GST)] for the value "NSW".
I want to modify this code to check for any of the Australian states/territories (ACT,NSW,QLD,WA,SA,NT,VIC,TAS) in that column, but also check if the value contained in the column [Item #] is a number.
In English - If the value in "Net Billings (exc GST)" is one of the states AND the value in "Item #" is a number then return the value in "Net Billings (exc GST)" else "null"
Bookmarks