Forum Discussion

TA_'s avatar
TA_
Regular Visitor
11 months ago
Solved

Column exchange with a calculated column?

Hello, I am stuck with the following problem; I need to edit a column cointaining unique keys. Unfortunately, a number of keys have changed within the last year or so. There is an operation to compa...
Need Help
  • MFelix's avatar
    MFelix
    11 months ago

    Hi TA_ ,

     

    What are the columns you are using for the merge? Looking at the DAX code you should do the merge on the Info Table and match the Map_WE_ME[OldKey] with the Info[ID_WE_ME] then expand the Map_WE_ME[NewKey] on the resulting column. After that Replace the null by the  Info[ID_WE_ME]

     
    How are you setting the merge on the tables? Is on the info table or on the Map table?
     
    Can you share that specific line of code please.
MFelix's avatar
MFelix
Super User
11 months ago

Hi TA_ ,

 

I don't know how you are calculating the new column but I would redo that column in Power Query that way you can then rename or delete the previous column if not necessary.

 

Another question is that if you are doing a Lookupvalue function to generate a new column in another table I would also pass this calcution to the Power Query using the Merge option between queries this would allow more flexibility and ensure consistancy.

 

Can you please give more context on what you are calculating and how?