cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Max Date with 1 to x FILTER(s)

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V

## Re: Max Date with 1 to x FILTER(s)

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
5 REPLIES 5
Highlighted
Super User VII

## Re: Max Date with 1 to x FILTER(s)

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.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Highlighted
Resolver III

## Re: Max Date with 1 to x FILTER(s)

@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

Highlighted
Super User V

## Re: Max Date with 1 to x FILTER(s)

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Frequent Visitor

## Re: Max Date with 1 to x FILTER(s)

Thanks Ashish, your proposal works perfectly.

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

Highlighted
Super User V

## Re: Max Date with 1 to x FILTER(s)

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com