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]

     

     

AlienSx's avatar
AlienSx
Super User
2 years ago
    Table.ReplaceValue(
        your_table,
        each [DOJ],
        each [Designation],
        (v, o, n) => if Value.Is(n, Text.Type) then v else if Value.Is(v, Text.Type) then n else o, 
        {"DOJ", "Designation"}
    )