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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Elliott
Advocate II
Advocate II

Add New Column With Set Value (Text)

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
Elliott
Advocate II
Advocate II

Resolved....

 

Sorry for very stupid question.. Just forgot I could specify text within "xyz"

 

Wondered why it kept showing as "Failed to resolve name 'testing'. It is not a valid table, variable, or function name."

View solution in original post

1 REPLY 1
Elliott
Advocate II
Advocate II

Resolved....

 

Sorry for very stupid question.. Just forgot I could specify text within "xyz"

 

Wondered why it kept showing as "Failed to resolve name 'testing'. It is not a valid table, variable, or function name."

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors