Forum Discussion

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?

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]

Community 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]

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
Community Champion
2 years ago

You have to add them into-your query as a custom column.
- 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
  - dufoq3
    Community Champion
    2 years ago
    You addec just "" into Custom Column. You have to add my code there 🙂 Read carefuly my guidelines again please.