Forum Discussion

rtillery2000's avatar
rtillery2000
Frequent Visitor
8 years ago
Solved

add row based on missing data

I have to two DB's that I am trying to keep the same reports. here is the dilemma Table1 and Table 2 have all the same attributes but Table 2 has one that table 1 doesn't. This breaks the reportin...
Need Help
  • rtillery2000's avatar
    rtillery2000
    8 years ago

    not what I was looking for but it did help get to where I need to resolve the issue.

    Thank you.

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi rtillery2000,

 

It's hard to add rows. The solution could be creating a calculated table with all the attributes.

Table =
DISTINCT (
    UNION ( VALUES ( Table1[attributename] ), VALUES ( Table2[attributename] ) )
)

Capture

 

Best Regards,

Dale

  • rtillery2000's avatar
    rtillery2000
    Frequent Visitor
    8 years ago

    not what I was looking for but it did help get to where I need to resolve the issue.

    Thank you.