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

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.

1 Reply

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