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 ...
Create a new table as
calculateTable(Table, filter(Table, not(isblank(Table[Start Date]))))
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?