Forum Discussion
Formatting Column and Data
In a data file that I have brought into powerbi, one particular column/field is 98% made up of 5 or 6 numbers, and the balance is made up of a combination of numbers and letters, like this - DS2-1328...
if in both of your two tables the values do repeat - then you need to create a reference table. Then you join both tables to that.
i am having trouble finding any knowlege base articles on how to set up a reference table. can you direct me in the rigt direction ?
sorry I think I just invented that term and it is not official.....
a table that has all the values - but never a duplicate. The table could be a single column - though let's say a product table might have the official product # but then also a decriptor maybe even a unit price.
you can import it, or build it manually, or derive it by appending other tables' columns to a new table and then taking a DISTINCT/VALUES of it.