If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because…
Get the Text Length using Power Query M. If we want to use the Excel LEN function to get the length of…
Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you…
You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not an…
Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the…
There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace…
Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim,…
How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it…
Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how…
To simplify your data and aggregate them together we can Pivot the huge data table using Power Query Editor in Power BI….