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)),
2 Replies
littlevillage Change the first variable "x" in the LET formula to this:
x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),
