Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching SORT Numbers and Text Mixed as per correct Numerical Order in Power Query. and this video is uploaded by Bhavya Gupta at 2023-02-26T05:54:32-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [6aV8CL-vZEg]
| Name | SORT Numbers and Text Mixed as per correct Numerical Order in Power Query |
| Video Uploader | Video From Bhavya Gupta |
| Upload Date | This Video Uploaded At 26-02-2023 13:54:32 |
| Video Discription | Say Column Values are - 1Apple, 10Lichi, 3Grapes. If we Sort this Column in Ascending Order from the SORT option available in the UI, resultant Column Values will be - 10Lichi, 1Apple, 3Grapes. This is because the numbers in each Value are treated as Text and Sorted accordingly. Our desired result is - 1Apple, 3Grapes, 10Lichi. In this Video, we shall see that how we can get to our desired result using an Additional Parameter in Table.Sort M Function. Similar Idea can be extended to List.Sort as well. To learn more Custom Sorting in Power Query in detail, checkout the following Blog and Video by @BIGorilla : Blog - https://gorilla.bi/power-query/how-list-sort-works-in-m/ Video - https://www.youtube.com/watch?v=QBQMxSZHzZk [6aV8CL-vZEg] |
| Category | People & Blogs |
| Tags | People & Blogs Download MP4 | People & Blogs Download MP3 | People & Blogs Download MP4 360p | People & Blogs Download MP4 480p | People & Blogs Download MP4 720p | People & Blogs Download MP4 1080p |
