About Jerry_Fernandez

Jerry_Fernandez · 10-23-2020

Where should this code go? I tried entering this to slice but the result should be yes and no so it didn’t accept.

Jerry_Fernandez · 10-22-2020

Steve: SELECT( My Table[Wanted Column], ([_THISROW].[Thing] = [Thing]), TRUE ) Hi Steve, I have a table with multiple columns. I wanted to have a unique list of rows for the following: list of unique values from [service towers] under [segment]. list...

Jerry_Fernandez · 10-22-2020

Where should this expression be entered to have a unique list of rows?

Jerry_Fernandez · 10-21-2020

oh sorry… didn’t notice that its date first. While you here, can you give me a good app to review for a dashboard? Thank you, Aleksi.

Jerry_Fernandez · 10-21-2020

yes… the string yyyymmdd, I plan to do a column for date, week and month. I was able to source some formula in some topics ( DATE(CONCATENATE(RIGHT([dateStr],2), “/”, MID([dateStr], 5,2),"/", LEFT([dateStr],4))) ) however, it always resulted to error...

My Stats

richa-zamaheshw's Bio

Badges Jerry_Fernandez Earned

Recent Activity

Re: FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

Re: FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

Re: FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

Re: Date formatting - Text to Date

Re: Date formatting - Text to Date