Forum Discussion

Daniel_Fdrvc's avatar
Daniel_Fdrvc
Icon for Helper I rankHelper I
4 years ago
Solved

Add latest value from one table to another

Hello,   i've got some issues with adding latest value from one table to another, maybe someone could help me. So.. I've created new calculated table that stores distinct UNIQUE ID values from two ...
Need Help
  • Daniel_Fdrvc's avatar
    Daniel_Fdrvc
    4 years ago

    You won't believe... because latest value for same ID is always the same, even if that ID appears two or more times, simple lookupvalue function solves me everything. 

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Daniel_Fdrvc ,

 

Please try the following formula:

 

Latest value = 
VAR latestDate =
    CALCULATE (
        MAX ( 'Table 2'[Date] ),
        FILTER ( 'Table 2', 'Table 2'[ID] = 'Table 1'[Unique ID] )
    )
VAR latestValue =
    MAXX (
        FILTER (
            'Table 2',
            'Table 2'[ID] = 'Table 1'[Unique ID]
                && 'Table 2'[Date] = latestDate
        ),
        'Table 2'[Value]
    )
RETURN
    latestValue

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.