Forum Discussion
Solved
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. The...
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!