How to get value from other table based on last date

Question

Hi,&nbsp;If someone can help my, I am complete new in PBI.&nbsp;This is situation. I have two tables:&nbsp;Table 1ID&nbsp; &nbsp; Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value1&nbsp; &nbsp; &nbsp;01.01.2021&nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp;10.02.2021&nbsp; &nbsp; &nbsp; 32&nbsp; &nbsp; &nbsp;11.01.2021&nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp;17.02.2021&nbsp; &nbsp; &nbsp; 35&nbsp; &nbsp; &nbsp;15.01.2021&nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp; &nbsp;07.02.2021&nbsp; &nbsp; &nbsp; 2&nbsp;Table 2ID&nbsp; &nbsp;Last_Date&nbsp; &nbsp; Last_Value1&nbsp; &nbsp; &nbsp;10.02.2021&nbsp; &nbsp; &nbsp; ?2&nbsp; &nbsp; &nbsp;17.02.2021&nbsp; &nbsp; &nbsp; ?35&nbsp; &nbsp; &nbsp;07.02.2021&nbsp; &nbsp; &nbsp; ?&nbsp;&nbsp;How I can get Last_Value in Table 2 from Table 1?&nbsp;Tnx in advance 🙂&nbsp;

jameszhang0805 · Answer

Please try:if you want to remove the total number&nbsp;&nbsp;

vedranr · Answer

Sorry, your first solution ignore date and give me first value after maximum value, so that is not last value by date that I needed. Second isn`t work. But thanks for trying 🙂

Forum Discussion

How to get value from other table based on last date

2 Replies