Forum Discussion

Stharwani's avatar
Stharwani
Advocate II
8 years ago
Solved

Lookupvalue returning error

Hi,   I have a table which has movements for all assets.  For this one particular asset - 59397, I am trying to get the date it was last used and the lookup errors when I use the formula:    LUp...
Need Help
Show and Tell
Tips and Tricks
  • praiselyabraham's avatar
    praiselyabraham
    8 years ago

    In that case you can take 2 approaches:
    1. make sure the [New] column you create is having unique values; something like [rank-asset_id] instead of just concatenating, 

    2. Use the below DAX
    LookUpDate = LOOKUPVALUE(AssetMovementLine[CreatedDateTime], AssetMovementLine[AssetID], AssetMovementLine[AssetID] , AssetMovementLine[Rank],AssetMovementLine[Rank]+1)

    .

    However I would suggest you to follow the 1st approach as the second one is bit performance costly .

    Hope this helps your issue.

Stharwani's avatar
Stharwani
Advocate II
8 years ago

I am getting this possibly because there are more assets in the table?

praiselyabraham's avatar
praiselyabraham
Resolver II
8 years ago

In that case you can take 2 approaches:
1. make sure the [New] column you create is having unique values; something like [rank-asset_id] instead of just concatenating, 

2. Use the below DAX
LookUpDate = LOOKUPVALUE(AssetMovementLine[CreatedDateTime], AssetMovementLine[AssetID], AssetMovementLine[AssetID] , AssetMovementLine[Rank],AssetMovementLine[Rank]+1)

.

However I would suggest you to follow the 1st approach as the second one is bit performance costly .

Hope this helps your issue.