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
Icon for Community Champion rankCommunity Champion
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]

 

 

  • Aasozab's avatar
    Aasozab
    Regular Visitor
    2 years ago

    Hi dufoq3 . I got these errors when followed your steps:

    Please tell me:

    1. whether or not I followed your steps correctly?

    2. Why getting this error?

    TIA

     

    • dufoq3's avatar
      dufoq3
      Icon for Community Champion rankCommunity Champion
      2 years ago

       

      You have to add them into-your query as a custom column.

       

       

      • Aasozab's avatar
        Aasozab
        Regular Visitor
        2 years ago

        I have done so.

        Check thse steps and plz tell where I have made a mistake. and why i am getting error in last step and plz also tell what would be next steps?

        123456