Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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

jsauerla_0-1601994492413.png

3 REPLIES 3
Pragati11
Super User
Super User

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
 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

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... 

 

jsauerla_0-1601995595144.png

 

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors