Join 3 column data into 1 column only with DAX in Power BI - Direct Query connection

[Syndicate_Admin]

In the table I am working on three columns, the first three are zip codes. I want to combine all of them in one column with all Zip Codes. Union DAX syntax doesn't work for me (everything is in the same table). I can only work with DAX because I have the connection to the model by Direct Query (therefore I cannot use Power Query)

Thanks!

[v-robertq-msft]

Hi, @Syndicate_Admin 

Have Jihwan_Kim’s reply helped you to find the solution to this problem? Because the UNION() function is the only method to combine columns in DAX.

More info about the UNION() function in DAX

If so, would you like to mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim · Accepted solution]

Hi, @Syndicate_Admin 

please check the below.

New Table =
UNION (
VALUES ( 'Table'[Zip1] ),
VALUES ( 'Table'[Zip2] ),
VALUES ( 'Table'[Zip3] )
)

https://www.dropbox.com/s/231t1f44qm8nqtw/admin.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM