Forum Discussion

ranggafirmansya's avatar
ranggafirmansya
Regular Visitor
8 years ago
Solved

lookup value from table

Hello, I am new to this forum and fairly new to Power BI I am trying to lookup value from table service with a coloumn id_operation. relation of both table is coloumn vincode. how to lookup valu...
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

     

    Hi@ ranggafirmansya 

    When you add a column, It returns values must be one.

    You need to add another condition:

    SERVICE[ID_OPERATION]=1

    data = LOOKUPVALUE(SERVICE[date],SERVICE[VINCODE],CUSTOMER[VINCODE],SERVICE[ID_OPERATION],1)

    Result:

     

    Best Regards,

    Lin

     

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
8 years ago

LOOKUPVALUE is the function you probably want. 

 

I think it's easiest to just start typing data = LOOKUPVALUE(  and follow the tooltips, but in the end you will use something like this: 

 

Data =LOOKUPVALUE(Service[ID_OPERATION],Service[VinCode],WhateverThisTableNameIs[Vincode])

 

 

 

 

 

  • ranggafirmansya's avatar
    ranggafirmansya
    Regular Visitor
    8 years ago

    I have tried according to your suggestion, but I found the following error:

     

     

    what's the solution ?