Forum Discussion

Joachimnicho's avatar
Joachimnicho
Frequent Visitor
8 years ago

Return a value based on the latest date

Hi,   I have an issue.    I am trying to return a value, which is text, based on a date corresponding to the same row, but in a different column. The problem is, that I have som duplicate va...
bsas's avatar
bsas
Icon for Post Patron rankPost Patron
8 years ago

Hi Joachimnicho,

 

Could you please draw your table and table-result that you want to receive.

Joachimnicho's avatar
Joachimnicho
Frequent Visitor
8 years ago

Hi again,

 

This is a picture of the table. 

 

I wish to make a new column in a different table, where it returns the [Leverancetype] with the latest date [Datostempel].

I set the function to hold [Projektnr] from this table equal to [Job no] in the table I wish to post the new column with the [Leverancetype]. My formula looks like the following, but does not work unfortunately:

 

Leverancetype = LOOKUPVALUE(ProjektSpec[Leverancetype];ProjektSpec[Projektnr];'Job Task'[Job No_])&LASTDATE(ProjektSpec[Datostempel].[Date])

 

 

 

I hope this helps and makes the situation more clear! 

 

Thank you for your time!