Forum Discussion
geblerj
3 years agoFrequent Visitor
PowerBI altering data in custom column
I've loaded in a dataset from postgres, and I've created a custom column in Power Query, let's call it id, that concatenates two of the table's columns with a hyphen (let's call them employee_id and ...
- 3 years ago
Impossible to say without seeing your data and code.
Try using Text.Upper(employee_id) in your step that joins the 2 columns to get around the issue.
Phil
PhilipTreacy
3 years agoSuper User
Impossible to say without seeing your data and code.
Try using Text.Upper(employee_id) in your step that joins the 2 columns to get around the issue.
Phil
- geblerj3 years agoFrequent Visitor
That worked, thank you!