Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Column data = table name

I would like to append two tables, but I would like to be able to differenciate which data came from which table. Is there an easy way to pull the table name into the a column named "table" and use t...
Need Help
  • Baskar's avatar
    Baskar
    10 years ago

    Add table name with your value using "Add Prefix" In Query Editor Window . Then you do the merging.

     

    Eg. Vale = 103, Then Add "Table1" , O/P = Table1103

     

    From the DAX  

    Create new Column 

    Value = MID(O/P,7,5) -- 5 give how long max digit u have 

     

    Then u change the column datatype as Integer .

     

     

    It will work.

     

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Anonymous

 

You need to add the custom column in Query Editor, not under Data tab.

 

 

Both tables need to add this table name column, then you can append correctly.

 

Regards,

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Add table name with your value using "Add Prefix" In Query Editor Window . Then you do the merging.

 

Eg. Vale = 103, Then Add "Table1" , O/P = Table1103

 

From the DAX  

Create new Column 

Value = MID(O/P,7,5) -- 5 give how long max digit u have 

 

Then u change the column datatype as Integer .

 

 

It will work.