Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

how to add text valuecolumn in data sets

Hello, Example of current situation: I have 2 separate data sources that I am collating into the same table using UNION DAX command, However, each table does not have any sort of unique identifier. Therefore, I would like to add a new column to each table with a unique identifier such as 'TABLE1' and 'TABLE2' So that when the new table is created using UNION, I will be able to see which row is coming from which table/source (Also allowing me to create my reports based on the unique identifiers). So what I am simply after, is a way to add a new column to an existing table which I can specify a text string that will input into every row.

 

Thanks in advance.

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee

@kunkumuriarjun

 

Check a DAX expression as below.

UnionTbl =
UNION (
    SELECTCOLUMNS (
        'Table1',
        "TableName", "Table1",
        "COLUMN1", Table1[Column1],
        "COLUMN2", Table1[Column2],
        "COLUMN3", Table1[Column3]
    ),
    SELECTCOLUMNS (
        'Table2',
        "TableName", "Table2",
        "COLUMN1", Table2[Column1],
        "COLUMN2", Table2[Column2],
        "COLUMN3", Table2[Column3]
    )
)

Capture.PNG

View solution in original post

1 REPLY 1
Eric_Zhang
Employee
Employee

@kunkumuriarjun

 

Check a DAX expression as below.

UnionTbl =
UNION (
    SELECTCOLUMNS (
        'Table1',
        "TableName", "Table1",
        "COLUMN1", Table1[Column1],
        "COLUMN2", Table1[Column2],
        "COLUMN3", Table1[Column3]
    ),
    SELECTCOLUMNS (
        'Table2',
        "TableName", "Table2",
        "COLUMN1", Table2[Column1],
        "COLUMN2", Table2[Column2],
        "COLUMN3", Table2[Column3]
    )
)

Capture.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.