Create new table

[Joak]

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 ? 

I'd like to transform this

A      B     C     D

a       b     c     0

a1    b1    c1   d1

a2     b2   c2    0

To this : 

A     B     D

a1    b1   d1

I guess I have to use SUMMARIZE but I don't really know how. 

Would it be like : 

SUMMARIZE(Table1;Table1[A];Table1[B];Table1[D]<>0;Table2) 

Thanks !

[Vvelarde · Accepted solution]

@Joak

Hi Create a new Table with :

Dwithoutzeroandblanks = FILTER(Table1,Table1[D]<>"0" && Table1[D]<>BLANK())

Regards

Victor

Lima - Peru

[Joak]

thanks ! 

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 ?

[Vvelarde]

@Joak

Yes, you can use columns from different tables in a measure or calculated columns

Regards

Victor