Max Date with 1 to x FILTER(s)

[novicenovice]

Dear all,

I need to get the max [DATE_TODAY] on table (B) with specific conditions (Table_A[S_ORDER] = Table_B[S_ORDER} and I got the max date of the full table B.

Someone can help me ? thanks 🙂

Table A

S_ORDER	TEST1	Details
5308034	22/11/2017	=MAXX(FILTER(TABLE_B;TABLE_A[S_ORDER]=TABLE_B[S_ORDER]);TABLE_B[DATE_TODAY])

Table B

DATE_TODAY	S_ORDER
13/11/2017	5308034
14/11/2017	5308034
15/11/2017	5308034
16/11/2017	5308034
17/11/2017	5308034

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula in Table A

=CALCULATE(MAX(Table_B[Date_Today]),FILTER(Table_B,Table_B[S_Order]=EARLIER(Table_A[S_Order])))

Hope this helps.

[novicenovice]

Thanks Ashish, your proposal works perfectly.

&Thanks also to PXG08680 for your help but I still got result as error.

[Ashish_Mathur]

You are welcome.

[pxg08680]

@novicenovice

Make a column in Table2 as above. Left one is Table1 data and right is Table2 data with extra column of your req.

You can do the same in Table1 also if you want to.

Regards,

PXG08680

[parry2k]

i assume table a is related to table b on s_order

in table a, add following measure

Max Date = MAX(Tableb[Date_Today])

Dop S_Order and Max Date (new measure) in table visual and see if you get the result.