Forum Discussion
Solved
How to filter values 0 in an array
Hi, I need to filter values 0 in an array, and hope the result a dynamic array I have added an image and the link of sample file Hope for your help Thank you
littlevillage Change the first variable "x" in the LET formula to this:
x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),
littlevillage Change the first variable "x" in the LET formula to this:
x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),