Forum Discussion
Create a new table by adding two columns from another single table, and excluding any blank values?
I have a table with repeating values in the index column, and a third column that has values only in some rows
In power BI, I want to create a brand new table that selects the CompanyID column and Start Date column (not Contact Date), and excludes any rows that have a blank value.
Data should look like this after (NO filtering, must exclude blanks in the query)
Create a new table as
calculateTable(Table, filter(Table, not(isblank(Table[Start Date]))))
2 Replies
Create a new table as
calculateTable(Table, filter(Table, not(isblank(Table[Start Date]))))
amitchandak this works, but curious, if I want to add another not(isblank column, where do I put it in the filter?
calculateTable(Table, filter(Table, not(isblank(Table[Start Date]), not(isblank(Table[Order Date])))) doesn't work. Any way to simply add another filter?