Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

How to filter values 0 in an array

Iron 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 littlevillage (Iron Contributor)
Solution

@littlevillage 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

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)
Solution

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

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

View solution in original post