https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461499#M132037 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="626949" data-lia-user-login="alexgoh" class="lia-mention lia-mention-user">alexgoh</a>&nbsp;<BR />To get the latest comment you may try (calculated column in TableA)</P> <LI-CODE lang="javascript">Latest Comment = MAXX ( TOPN ( 1, FILTER ( TableB, TableB[ID] = TableA[ID] ), TableB[Date] ), TableB[Comment] )</LI-CODE> <P>&nbsp;To get the correct % try using CALCULATE - ALL ( 'Tab;e'[Mutual Consensus] ) at the denominator</P> Thu, 05 Oct 2023 11:01:53 GMT tamerj1 2023-10-05T11:01:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461453#M132033 <P>Hi All,&nbsp;<BR /><BR />I have two problem and would like to seek for expert help on what dax should I used:</P><P>&nbsp;</P><OL><LI>when I try to look up the latest value from one tables to anothers. Illustration as below:&nbsp;<BR /><img /><BR />I have two tables, Table A store all the ID (which is unique field) and Table B store all the comment/value with ID and date.<BR />I wanted to lookup / link the value to show only latest comment. Have tried to use lookup dax but it got error whereby multiple value returned ?&nbsp;<BR /><BR />Question: Any dax i can use to achieve above ?&nbsp;<BR /><BR /></LI><LI>I have a chart on to show the count of item in my dataset by date.&nbsp;<BR />However, I would like to show in %, please refer to pic 2.&nbsp;<BR /><BR />Picture 1&nbsp;<BR /><img /><P><BR />Picture 2&nbsp;<BR />However, the % of grant total seem off. What I want to achive is % / Total by each date.<BR />Each date, the % should be 100%.&nbsp;</P><img /><P><BR />Question: Any dax/chart I can use to achive to show the % over each date ?&nbsp;</P></LI></OL><P>&nbsp;</P><P class="lia-indent-padding-left-60px">&nbsp;</P><P class="lia-indent-padding-left-60px">&nbsp;</P><P class="lia-indent-padding-left-60px">&nbsp;</P><P>&nbsp;</P> Thu, 05 Oct 2023 10:32:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461453#M132033 alexgoh 2023-10-05T10:32:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461497#M132036 <P>Hi, <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="626949" data-lia-user-login="alexgoh" class="lia-mention lia-mention-user">alexgoh</a>&nbsp;&nbsp;</P><P>Try with treats function</P><P>&nbsp;</P><P>Create measure</P><P>Comment= calculate ('tableb'[comment], treats ('tablea'[Id], 'tableb'[I'd]</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly</STRONG></P> Thu, 05 Oct 2023 11:01:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461497#M132036 Dangar332 2023-10-05T11:01:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461499#M132037 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="626949" data-lia-user-login="alexgoh" class="lia-mention lia-mention-user">alexgoh</a>&nbsp;<BR />To get the latest comment you may try (calculated column in TableA)</P> <LI-CODE lang="javascript">Latest Comment = MAXX ( TOPN ( 1, FILTER ( TableB, TableB[ID] = TableA[ID] ), TableB[Date] ), TableB[Comment] )</LI-CODE> <P>&nbsp;To get the correct % try using CALCULATE - ALL ( 'Tab;e'[Mutual Consensus] ) at the denominator</P> Thu, 05 Oct 2023 11:01:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Look-up-latest-value-from-another-tables/m-p/3461499#M132037 tamerj1 2023-10-05T11:01:53Z