Nested If formula in Power Bi Query custom column issue
I have the following code in a custom column, and it simply refuses to accept any variant of the very first then string value I want to add. Doesnt matter what I do, I get the same error. this seems like basic functionality, but i cannot get it to work at all. (I Can get it to work on the table view, but I really want this within the query.
Any help will be greatly appreciated as I need this custom column for use elsewhere in the power bi report