Forum Discussion
Solved
How to append text to non-numerical values?
Hello, I am new to Power BI, advanced user for Excel. I'm trying to update specific values in a column if the are alpha character. The coulmn is text, but has both numbers and letters. I...
In the Power Query M editor add a custom column:
let x = try Text.InferNumberType([Number]) in if x[HasError] then Text.Combine({[Number],"/28"}) else [Number]
In the Power Query M editor add a custom column:
let x = try Text.InferNumberType([Number])
in if x[HasError]
then Text.Combine({[Number],"/28"})
else [Number]
Worked like a charm, thank you very much