Forum Discussion

satlasg's avatar
satlasg
Helper I
8 years ago

Get most recent values on new table column

Hello,  I have two tables A & B with "many to one" relationship, as below:                I am looking for a formula to fill in 'Table B'[Value Latest] based on the Value from the more...
Need Help
satlasg's avatar
satlasg
Helper I
8 years ago

nickchobotar

 

I am getting the following when using the formula you provided as Column:

 

 

 

Please try this option. Works both as calc column and measure.

 

ColumnName = 
CALCULATE(
    VALUES(Table1[Value]),
    LASTDATE( Table1[Date])
)

 

 

 

 

satlasg's avatar
satlasg
Helper I
8 years ago

nickchobotar you are right, apologies.

However, i have tested your code and that is where i ended:

satlasg wrote:

nickchobotar

 

I am getting the following when using the formula you provided as Column:

 

 

 

Please try this option. Works both as calc column and measure.

 

ColumnName = 
CALCULATE(
    VALUES(Table1[Value]),
    LASTDATE( Table1[Date])
)

 

 

 

 

 


I also checked the IDs and there are no duplicates., cannot figure where the "single value was expected" comes from.

Thanks for the pbix file.

 

Will try to implement the M code and see where it ends.

 

G