Solved: Suggested Value sorted by timestamp - Page 2

Quentinlebg · 07-13-2021 07:10 AM

Hello,

My goal is to sort my data by timestamp, but I can’t figure it out…

I tried doing that:
SELECT(Quote[Title], in([Timestamp],SORT(SELECT(Quote[Timestamp], isnotblank([Title] = [_THISROW].[Title])), false))).

I thought that using sort() like that would change the list and put it in order but it doesn’t. It is the same as if I did Quote[Title]. I was told to use ORDERBY() but even with it I can’t figure it out.

Any suggestion would be appreciated!

Steve

Replace the entire ORDERBY() expression I provided earlier with this:

ORDERBY(
  FILTER("Quote", TRUE),
  [Timestamp],
    FALSE
)

Then use this as your Suggested values expression:

([Ordered Quotes][Title] - LIST(""))

View solution in original post