How do I create a new table, and populate it with columns from another table with no blank rows?

[Anonymous]

I have a massive table with 50+ columns in Power BI. I want to create a brand new table, and select just 5 columns, and also filter out blank values for all of these columns

1. OrderID
2. Start Date
3. End Date
4. Revenue
5. Cost

The table should look like this -- note there are no blank values, even if the original table has multiple order ID repeating without any values

[Pragati11]

Hi @Anonymous ,

For creating a new table out of your big table, you can simple use the following DAX for New table creation:

Small Table = SELECTCOLUMNS(ClothingSales, "Category", ClothingSales[Category], "Date", ClothingSales[Date], "Sales", ClothingSales[Sales])

Regarding blank values, you will have to give more detail on how the blank values are in your data column, or provide a sample data with blank values.

Thanks,

Pragati

[Anonymous]

Hello @Pragati11 : Here's an example of my table, below, which shows the blank values -- if I were to filter them out, there would be only one Order ID, with no blank entries

I just do not know how to use filter and not(isblank()) DAX with Select Columns statement... 

[Pragati11]

Hi @Anonymous ,

As you say only one order Id will be remaining in the table after removing blanks, does that mean removing any Order IDs that don't have values in other 3 columns?

Can you paste the expected output please? Also share your input data in a format so that I can easily copy and paste it in Power BI.

Thanks,

Pragati