Forum Discussion

vat2do's avatar
vat2do
Helper III
4 years ago
Solved

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

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 blan...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.