Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
Thanks Ashish, your proposal works perfectly.
&Thanks also to PXG08680 for your help but I still got result as error.
You are welcome.
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
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |