SOLVED

How to filter values 0 in an array

Frequent Contributor

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

small_village_0-1661062763500.png

 

 

2 Replies
best response confirmed by small_village (Frequent Contributor)
Solution

@small_village Change the first variable "x" in the LET formula to this:

x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),

@Riny_van_Eekelen 

it's unbelievable, you make it so simple

Thank you so much