Forum Discussion

Joak's avatar
Joak
Frequent Visitor
9 years ago
Solved

Create 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 ? 

 

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 !

  • Joak

     

    Hi Create a new Table with :

     

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

     

    Regards

     

    Victor

    Lima - Peru

3 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    Joak

     

    Hi Create a new Table with :

     

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

     

    Regards

     

    Victor

    Lima - Peru

    • Joak's avatar
      Joak
      Frequent Visitor

      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's avatar
        Vvelarde
        Community Champion

        Joak

         

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

         

        Regards

         

        Victor