Help extracting Latest Note from second table.

[SurendraP]

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. 

[v-jiascu-msft]

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

[Ashish_Mathur]

Hi,

Share your datasets and also show your expected result.