Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

IF Formula Help

Dear All    İ have  two table as below Table A and Table B  . İ would like create vlookup for Table B and see " Install Cost"  but on Table B i only want to see " 20A" group's cost on table B .How ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    erhan_79 

     

    Please see if this is what you want.

    Column = IF(TableB[Group]="20A",LOOKUPVALUE('TableA'[InstallCost],TableA[group A],TableB[Group]),0)

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

erhan_79 

 

Please see if this is what you want.

Column = IF(TableB[Group]="20A",LOOKUPVALUE('TableA'[InstallCost],TableA[group A],TableB[Group]),0)

parry2k's avatar
parry2k
Super User
6 years ago

erhan_79 I would recommend to set relationship between both the tables on group column and it will be 1-1 relatioship since group value is unique

 

and now you can simply add the column

 

New Install Code = 
IF ( TableB[Group] = "20A", RELATED ( TableA[Install Cost ), 0 )

 

Lookup can be very slow and that was the reason I asked those questions, I don't like to give the answers without knowing the full scenario. 

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡