Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |