Creating User name List: Gathered in one column from from 2 different columns from two dif tables

[EWBI]

I need to create a master list of users from 2 different data sources.

there is a user name list in each table with different user names that I want to zipper together into one column in a new table that I can use as a Master User List.

The 2 columns i want to zipper together are "User" from table 1 with "Arrival User" from table 2.

Please let me know if there is a way.

Example table comlumns below.

Table 1

Time of Access

User

Date of Service

Location

Login Dept

Dept

ID

New?

Context

Vrf User

Elapsed Time

Active Time

Source

Type

UserName1

UserName2

UserName3

UserName4

Table 2

Location	Arrival Dep	Account ID	Arrv Date/Time	Arrival User	Event User
				UserName30
				UserName31
				UserName32
				UserName33
				UserName34

[EWBI]

This did the trick!! You are awesome!! Thank you so much!!!

[quantumudit · Accepted solution]

Hello @EWBI 

You can accomplish this with DAX. Below is the DAX formula for the calculated table:

UserTable = UNION(ALL('Table 1'[User]), ALL('Table 2'[Arrival User]))

Navigate to the "Modeling" tab, select "New Table" to create a calculated table using DAX, and input the formula provided. Afterward, you can establish a relationship from your consolidated "UserTable" to other tables, as illustrated in the screenshot.

Here is the Power BI file for your reference: Power BI File (This link will expire on 12th Sept 2023) 

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree