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.

praiselyabraham's avatar
praiselyabraham
Resolver II
8 years ago

Hi , 

 

I am not sure what exactly your issue is, I tried replicating it in my end and it worked as normal. Providing the screenshot of it.

Regards,

Praisely

  • Stharwani's avatar
    Stharwani
    Advocate II
    8 years ago

    • 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.