Combining Unique "supplierName" Values from Multiple Tables in Power BI

[FrederikB]

I have these 5 tables:
- Booking submission
- Conversation started
- New Message
- Quick Search
- Supplier request

All of them have a column called "supplierName".

I want to make a page where the user picks a supplier, and gets information regarding this supplier from all of the different tables.

To achieve this, I want to make a new table with the column "_allSupplierNames", that includes all distinct values of supplierName, across the different tables.
I have tried many things, but I keep getting errors. This is what my last try was:
1) Create a new table
2) Create a new column
3) With DAX write: 

_AllSupplierNames = UNION(
    VALUES('Booking submission'[supplierName]),
    VALUES('Conversation started'[supplierName]),
    VALUES('New Message'[supplierName]),
    VALUES('Quick Search'[supplierName]),
    VALUES('Supplier request'[supplierName])
)

But I keep getting errors, whatever I try.

Help a brother out.

Thanks.

[Ashish_Mathur · Accepted solution]

Hi,

Use the Query Editor to create that table.  Append all tables and remove all columns other than the Supplier name column.  Right click on the column and select Remove duplicates.  In the formulas bar, type ,comparer.OriginalIgnoreCase

before the closing bracket to make the operation case insensitive.

[vicky_]

Can you share the error message(s)? it's a bit hard to find out what's wrong without that info. 
From what I can see, your dax should work.