New Bug Encountered: max expression always returns the 1000th row value in from google sheets

[reggieneo]

the expression :ANY(
SELECT(
Sales Summary[Actual Money in The Bank ],
[Timestamp]
= MAX(Sales Summary[Timestamp])))" always returns the values in the 1000th rows.

tried it several times.

“APP NAME”: GS1SALESNew-5318792

[Marc_Dillon]

The expression assistant only uses a max of 1,000 rows by default, when testing. Is that your issue? Or are the actual values in the app wrong?

[reggieneo]

it is actually is not getting past 1000 on this table (Sales).
I have replaced the googles sheets and loaded it again and the result is still up to 1000th rows.

I created the same expression referring to a different tables with 3000plus rows and no problem.

"expression:
ANY(
SELECT(
order details[Order Price],
[Timestamp]
= MAX(order details[Timestamp])))

[Marc_Dillon]

reggieneo:

it is actually is not getting past 1000 on this table (Sales).

Show some screenshots of the situation please.