Forum Discussion
Table relationship with non-item
This might be easy, but I can't seem to figure it out. I have two table table with 1 (unquie WBSs and large category) to M (large table with many WBSs) relationship for a column with WBS numbers. Then I add a filter of Category to view the large table in a table format. For any WBS not found in the unique table, can I aumatically refer them to a specific Category, so they don't show as '(Blank)'?
Hi hpatel123 ,
Ideally your unique WBS table should hold all possible values. We typically refer to this as "referential integrity" where the relationship and data quality should be consistent to prevent incorrect or incomplete data. When one or more key fields are missing key values we call this an "RI violation".
If I'm not mistaken, you have a field called "Category" which can sometimes be blank and you'd like it to default to a certain category? The easiest way is within powerquery where it is possible to replace those values:
You can also do it in DAX as well but as a new calculated column:
2 Replies
hnguy71Super User
Hi hpatel123 ,
Ideally your unique WBS table should hold all possible values. We typically refer to this as "referential integrity" where the relationship and data quality should be consistent to prevent incorrect or incomplete data. When one or more key fields are missing key values we call this an "RI violation".
If I'm not mistaken, you have a field called "Category" which can sometimes be blank and you'd like it to default to a certain category? The easiest way is within powerquery where it is possible to replace those values:
You can also do it in DAX as well but as a new calculated column:
that helped! thank you!
