About Enrico_Emil_Del

Enrico_Emil_Del · 04-10-2021

I get this error when trying to get the sum of a list of decimal numbers Here is my table: And here is the full formula for Upper Category LIst: SELECT(Data[Amount], AND( ([Upper Category] = [_THISROW].[UpperCategory]), ([TransactionType] = [_THISROW...

Enrico_Emil_Del · 04-11-2021

Hi found the formula to use from another thread: [_THISROW] = INDEX( FILTER( Categories, [UpperCategory] = [_THISROW].[UpperCategory] ) , 1 )), (NOT([Upper Category List] =0) Basically the table I wanted to slice had columns with duplicate row entrie...

Enrico_Emil_Del · 04-10-2021

Marc_Dillon: [_THISROW] = INDEX( FILTER( thisTable , [column] = [_THISROW].[column] ) , 1 ) This saved me thank you!

Enrico_Emil_Del · 04-10-2021

I also have the same question. I need my slice to only retain the unique values. Thank you!

Enrico_Emil_Del · 04-10-2021

Hi Suvritt! That definitely solved the problem! Thank you so much!

Enrico_Emil_Del · 03-20-2021

Is it possible Choose the product based on an entry? I basically want to add two rows but the value of one column of each row will vary and will be selected on a form. Is this possible with what you did?

My Stats

Neo2023's Bio

Badges Enrico_Emil_Del Earned

Recent Activity

SUM function requires a list of numeric inputs

Re: Display Only Duplicate Values in a slice

Re: Show UNIQUE values of a REF table

Re: Display Only Duplicate Values in a slice

Re: SUM function requires a list of numeric inputs

Re: New Action: Add a Row to a table