Forum Discussion
nixonyx
Helper I
Helper IFind value in column a, set value in column b
I have a list of service desk incident records. There is some missing data that occurs when the customer cannot be identified (or does not need to be identified). Currently, when reporting, we fi...
The "easy" way to do this would be to create a new column like Department1 in the query editor and use a formula like:
= if [User Name] = "unknown user" then "unknown user" else [Department]
nixonyxHelper I
Helper II will try again. I did your version first but that didn't work so I looked for if functions used in power bi which lead me to DAX.
I cannot find an IF function in the M query specification but have to admit I haven't clicked on every category.
I will try again.
nixonyxHelper I
Helper IOk, must have been a typo the first time. Sorry to have been a pain
Thank you for your help.