fbpx

Tag

Power Excel

Delete Steps Until End By Power Query

If you want to delete some steps, you can do it in one shot. The Power Query Delete Until End feature helps to delete as many steps up to the end in one click. Delete Steps Until End By Power Query Let us understand this feature with the help of an example. Step 1: Load...
Read More

Data Type Conversion With ‘M’ Using Power Query

Data Type Conversion With ‘M’ with Power Query. Sometimes it happens that the things we want to do are not built in the user interface.  But Power Query’s programming language M has made this possible. Data Type Conversion With ‘M’ Using Power Query One of the unique functionality of M is that it takes data types very...
Read More

Use Excel’s Right Function With M To Extract Right Side Data

How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it is not supported in M. But we can use the RIGHT Function in M in other way using Power Query and the Text. End formula! Use Excel’s Right Function With M To Extract...
Read More

Replicating Excel’s Find Function With ‘M’ in Power Query

In the above example, you learned how to concatenate the columns using the M language. Unfortunately, not all of the Excel’s formulas can be used in M query. Replicating Excel’s Find Function With ‘M’ Using Power Query For instance, if we want to use Excel’s FIND function to find a specific character in the text,...
Read More

Best Ways to Import Data From CSV in Power Query

Now you know how to import data from an XML file in Power Query. But what if your data source is in the form of a CSV file? There is no need to worry if you have your data inside a CSV file (Comma Separated Values). This is because it’s very easy to import data...
Read More

Top 5 Ways to Import Web Data in Power Query

The good thing with Power Query is that there are multiple ways to pull in data. Import Web Data Using Power Query One of the ways is to get data from the internet by using the importing web data feature.  Let us see how we can parse a webpage and use it for Power Query....
Read More

Consolidate Multiple Excel Workbooks in Power Query

The limitation of Excel of consolidating multiple Excel workbooks into one has overcome by Power Query.  Power Query can do this consolidation task in a couple of minutes. This is explained below within a few easy steps.   Consolidate Multiple Excel Workbooks By Power Query Step 1: Open Excel Workbook from Folder Suppose you have...
Read More
1 2