Using Power Bi create new table using specific value from other column avoiding blanks

[vat2do]

Hi Hope you have a good day,

I want to create new table using a specific value from old table's column while avoiding blanks

For Example,

I have old_Table with Category column with some blank values, I want to create new_Table using category column where category= blue only.

Any solution using power Bi or DAX

Thanks in advance

[v-stephen-msft · Accepted solution]

Hi @vat2do ,

You want create a new table by dax, right?

Try this dax formula to create a new table.

Calculated Table = FILTER('OldTable', [Category]<>BLANK())

Here's an example.

OldTable

NewTable

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.