Blog Posts on Different Topics of Power Query in Excel
Power Query’s Index Column numbers every row and renumbers when you refresh, so new or removed rows never break the sequence. You can start at any number and add prefixes like INV-0150. WhereAdd Column → Index Column RefreshRenumbers automatically Works inExcel 2016 and later Step 1: Load the data Click in the data → Data … Read more
I this blog post, I will explain the Fill Up and Fill Down Transformation steps in Power Query of Excel with a simple example. Following is the collection report of Infinity Saga which comprises of 23 Marvel movies that were released in 3 Phases. I want to create two reports from this data. 1. Phase-wise … Read more
Power Query's Text.Reverse reverses each text string in a column, so Ajay becomes yajA. Wrap it in Text.Proper to tidy the capitals, and refresh whenever the list changes. M functionText.Reverse Tidy capitalsText.Proper(Text.Reverse(…)) Works inExcel 2016 and later, Power BI Step 1: Load the list Click in the list → Data → From Table/Range → OK. … Read more
Normalized Data using Power Query in Excel
