topic How to get value from other table based on last date in DAX Commands and Tips

How to get value from other table based on last date

VedranR — Fri, 26 Feb 2021 16:53:23 GMT

Hi,

If someone can help my, I am complete new in PBI.

This is situation. I have two tables:

Table 1

ID Date Value

1 01.01.2021 1

1 10.02.2021 3

2 11.01.2021 1

2 17.02.2021 3

5 15.01.2021 7

5 07.02.2021 2

Table 2

ID Last_Date Last_Value

1 10.02.2021 ?

2 17.02.2021 ?

5 07.02.2021 ?

How I can get Last_Value in Table 2 from Table 1?

Tnx in advance 🙂

Re: How to get value from other table based on last date

jameszhang0805 — Sat, 27 Feb 2021 01:21:37 GMT

Please try:

if you want to remove the total number

Re: How to get value from other table based on last date

VedranR — Tue, 02 Mar 2021 07:44:56 GMT

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 🙂