Monthly Archives: April 2022

Keep the columns you need with #PowerQuery

Posted on April 24, 2022 by MF

When we import data from a data source, be it a data warehouse, a CSV/TXT file, or even an Excel Table, there are chances that there are many more columns than needed for analysis. This is particularly true when we … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

A twist to turn Keep Duplicates into Keep Unique in #PowerQuery

Posted on April 7, 2022 by MF

In Power Query Editor, there is a button of “Keep Duplicates” in the ribbon. It’s located under Keep Rows in the section of Reduce Rows in the Home tab of the ribbon.     With this, it is super easy … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Keep the rows you need with #Excel Power Query

Posted on April 2, 2022 by MF

When we import data into Power Query editor, we should set the scope of data that we need. That means selecting only the rows and columns required for further processing. In the following video, I will show you different ways … Continue reading →

Rate this:

Posted in Power Query | Tagged , , | Leave a comment