cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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_ORDERTEST1Details
530803422/11/2017=MAXX(FILTER(TABLE_B;TABLE_A[S_ORDER]=TABLE_B[S_ORDER]);TABLE_B[DATE_TODAY])


Table B

DATE_TODAYS_ORDER
13/11/20175308034
14/11/20175308034
15/11/20175308034
16/11/20175308034
17/11/20175308034

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V
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
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Highlighted
Super User VII
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.






Did I answer your question? Mark my post as a solution.

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





Highlighted
Resolver III
Resolver III

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

@novicenovice

a1.PNG

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
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
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

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
Super User V

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

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors