Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
84 | |
79 | |
62 | |
62 | |
51 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |