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 ?  ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Joak

     

    Hi Create a new Table with :

     

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

     

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

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
9 years ago

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
    9 years ago

    Joak

     

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

     

    Regards

     

    Victor