Forum Discussion
PowerBI Comparable to DataStruct
Hi,
I'm not fully familiar with some of the terminology you use however I think you're looking to ensure every record in one table as a related value in another?
In Power Bi if you create a relationship between the two tables I'm assuming it will form a 1 to many relationship?
There are then various ways to check that referential integrity is intact.
Easiest is to add a calculated column to the table on the many side and use RELATED.
Eg
RelatedId = RELATED ( OneSideTable[Primary Key] )
You can then filter to records where this is not the case.
If I'm missing the point entirely let me know and try and find some common terminology!
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.
