Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Delete rows if blank field

I created two columns related to another data table. I need to delete rows with blanks. I go to query editor and I do not see the columns I created so I can filter out the rows with blanks in the new...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Anonymous

    If you want to filter out blank row in report view, you can set "show item when the value is not blank" in Visual Filter container.

     

    If you want to change the data model with no blank value from column related from other tables.

    You could use the formula to create a new table.

    table = FILTER(ALL(Sheet2),[Column]<>BLANK())

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous

If you want to filter out blank row in report view, you can set "show item when the value is not blank" in Visual Filter container.

 

If you want to change the data model with no blank value from column related from other tables.

You could use the formula to create a new table.

table = FILTER(ALL(Sheet2),[Column]<>BLANK())

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes! Thank you very helpful!