Get Max Date Ignoring dimension

[Anonymous]

Hi,

I've attached an app, I really could use your help.

In that app, I have a table with StoreCode | ProductCode | MaxDate | SumQuantity.

I want to get the MaxDate for StoreCode regardless ProductCode.

Example:

when I have StoreCode = 2383 I want  MaxDate = 2016-06-01 in every occurrence of StoreCode = 2383.

And in SumQuantity I whant the value of sum Quantity in that date.

Can you please help ?

Thanks in advance,

Sílvia

[sunny_talwar · Accepted solution]

Try this:

Date(Max(TOTAL <StoreCode> {<RecordType = {"Stocks"}>} Date), 'YYYY-MM-DD')

[Anonymous]

Once again I hit my head on a simple thing

Thanks a lot Sunny

[miyako_FLO]

Hi! I am looking at this post as I have the same problem. I want to understand what "{<RecordType = {"Stocks"}>}" in the above solution is doing, why we have to add this in the script (both as measure in a table and load script declaration on "'Stocks' AS [RecordType]".

Can anyone explain to me? I will adapt the solution to my app but want to understand why these extra elements are necessary.

Thank you!

Miyako

[miyako_FLO]

This approach didn't work out for my issue so please ignore my above question. I will post a new query to get your help. Thank you!