This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Guys,
I am looking for something which can get latest date from my next table.
I have two tables, 1st table contains all data except note , from 2nd tabel I just want lastest UpdatedNote, my 2nd table has lot of values for one item so when I place note into powerbi that brings duplicate entries and not proper too. In both table we have modified date column and Id column, relationship is on ID column. I tried doign 'Last', first' and other options too but nothing is giving me proper result, please sugest further if there is any dax formula or anythign else..
Thank you.
Hi @SurendraP,
Try this formula as a Calculated Column please. If it can't help, please provide a dummy .pbix file.
Column = CALCULATE ( MAX ( 'Table2'[Modified Date] ) )
Best Regards!
Dale
Hi,
Share your datasets and also show your expected result.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 35 | |
| 32 | |
| 27 | |
| 23 | |
| 16 |
| User | Count |
|---|---|
| 65 | |
| 50 | |
| 30 | |
| 25 | |
| 24 |