Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Lookupvalue brings in blank value

Hi! I am facing some issue with teh LOOKUPVALUE results. Basically I have master Table with ID's and Date and I have another Table with ID 1 , ID 2, Date 1 & Date 2 as columns. The Relatuonship betw...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , One of these two should work

    Both as new columns

    Date 2 = minx(filter(table2,[ID 1] =earlier([ID 2])),[Date1])

    Date 2 = minx(filter(table1,table1[ID ] =(table2[ID 2])),table1[Date])

  • Anonymous's avatar
    Anonymous
    6 years ago

    I was using the LOOKUPVALUE function itself. I think I have figured out and it does work in both the scenerios.

    Thanks for your help on this.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I was using the LOOKUPVALUE function itself. I think I have figured out and it does work in both the scenerios.

Thanks for your help on this.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous aha, I thought you have correct column name in the lookupvalue as you never put the table name,  never ever use anything without table name for columns and never use table name with measures, it is a best practice. This would have been solved quickly if I noticed the Id column is not from the correct table name.

 

Anyhow good to hear it is solved, that's all matter.