Forum Discussion
Table relationship with non-item
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:
Super UserHi 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: