Forum Discussion

JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
2 years ago
Solved

Append distinct selected columns in PQ

Hi there,   I have four tables, all of which hold two common columns called [Mailbox] and [Business Type] I want to append the four tables with distinct values of these two columns I tried bringi...
Need Help
  • BIstvan's avatar
    BIstvan
    2 years ago

    I suppose you need it for a dimension table. have you tried to duplicate the 4 tables. Disable the load on the duplicates. Leave just the 2 common columns. Then select Both columns and remove duplicates. Do it for all 4 duplicates same steps. Once done append them toghether. And on the appended table do again a duplicate removal on both columns.

JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
2 years ago

I need to do it in Power Query as dax will create circular dependency 

BIstvan's avatar
BIstvan
Icon for Resolver I rankResolver I
2 years ago

I suppose you need it for a dimension table. have you tried to duplicate the 4 tables. Disable the load on the duplicates. Leave just the 2 common columns. Then select Both columns and remove duplicates. Do it for all 4 duplicates same steps. Once done append them toghether. And on the appended table do again a duplicate removal on both columns.