Forum Discussion

Aasozab's avatar
Aasozab
Regular Visitor
2 years ago
Solved

How to swap some values between two columns in power query using either GUI elements or M code?

How to swap some values between two columns in power query using either GUI elements or M code?  
Need Help
Show and Tell
  • dufoq3's avatar
    dufoq3
    2 years ago

    Hi Aasozab, I recommend you to create new pair of columns with extracted values:

     

     

    [Extracted Date]

     

    if (try Date.From([Column1]) otherwise false) is date then [Column1] else [Column2]

     

     

    [Extracted Text]

     

    if [Column1] = [Extracted Date] then [Column2] else [Column1]

     

     

dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi, I dind´t provide the code with sample data, but you can create it either in power query vie Enger Data button or in excel and then import to power query.

 

The purpose was to show sou the way how to achieve expected result. You can use codes above by adding them separately as custom column. Just replace [Column1] with [DOJ] and [Column2] with [Designation]. Don't forget to set column name for first code: "Extracted Date".