Forum Discussion
PowerBI Comparable to DataStruct
Hey Guys,
thanks for the answers but they both dont satisfact me.
@bcdobbs I got a convention table with Serial Numbers which have been converted into a new format.
So the table i am including has partial still this old serial numbers in it, they may pop up multiple times, so i can't just match 1 colum to another.
It's more a Check if the number is an old serial number, and IF "true" then i swap it to a assigned new number.
I need the whole "table" i want to use for my charts with the same serial number format, right now i got a mixed format which doesnt sort my data then.
This sounds like something that can be done fairly easily in the query editor. Take your data table and merge it with a table that has the old --> new serial mapping, expand the new serial column, and write a conditional column to consolidate the serial number columns.