JoakFrequent Visitor9 years agoSolvedCreate new table Hello, I have a table with columns A, B, C, D; how can I create a new table with columns A, B and D with only the lines matching with rows of column D which are different from zero and null ? ...Show MoreVvelarde9 years agoJoak Hi Create a new Table with : Dwithoutzeroandblanks = FILTER(Table1,Table1[D]<>"0" && Table1[D]<>BLANK()) Regards VictorLima - Peru
Vvelarde9 years agoJoak Hi Create a new Table with : Dwithoutzeroandblanks = FILTER(Table1,Table1[D]<>"0" && Table1[D]<>BLANK()) Regards VictorLima - Peru
Vvelarde9 years agoJoak Hi Create a new Table with : Dwithoutzeroandblanks = FILTER(Table1,Table1[D]<>"0" && Table1[D]<>BLANK()) Regards VictorLima - Peru
JoakFrequent Visitor9 years agothanks ! It seems way more simpler than I thought. Then I guess it's possible to compare/add/ use formulas between two columns that are in deiffernet tables ?
VvelardeCommunity Champion to Joak9 years agoJoak Yes, you can use columns from different tables in a measure or calculated columns Regards Victor
Related contentCreate new tableLakehouse Table Generate Create TableCreate rows from 2 tablesCreating Date TablesCreating a couple of tables
