AasozabRegular Visitor2 years agoSolvedHow 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? Show Moredufoq32 years agoHi 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]
dufoq32 years agoHi 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]
dufoq32 years agoHi 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]
AasozabRegular Visitor2 years agoyes it works now. Thank you so much. I was confused by Note at bottom i.e. Note: Check this link to learn how to use my query. and was following these steps:
dufoq3Community Champion to Aasozab2 years agoYou're welcome. I have notes as signature, because usualy I use sample data.
Related contentHow to add headers without columns elements?Show rows having common elementsProblem with Cell Elements Formattingdisplay multiple elements with SELECTEDVALUETheme elements complete list
