Forum Discussion
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 !
Hi Create a new Table with :
Dwithoutzeroandblanks = FILTER(Table1,Table1[D]<>"0" && Table1[D]<>BLANK())
Regards
Victor
Lima - Peru
3 Replies
- VvelardeCommunity Champion
Hi Create a new Table with :
Dwithoutzeroandblanks = FILTER(Table1,Table1[D]<>"0" && Table1[D]<>BLANK())
Regards
Victor
Lima - Peru
- JoakFrequent 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 ?