Forum Discussion

FrankZappasMama's avatar
FrankZappasMama
Frequent Visitor
9 years ago
Solved

Calculations in Custom Column with LOOKUP and IF

Folks,   I'm struggling to create a custom column to the Project List dataset (explained below) that needs to lookup two values in the Project Cost dataset and return it. There are three relevant d...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi FrankZappasMama,

 

Have you tried the solution provided by erik_tarnvik above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. :smileyhappy:

 

Regards

  • FrankZappasMama's avatar
    FrankZappasMama
    Frequent Visitor
    9 years ago

    PowerBI legends,

     

    My apologies for not replying, my week has been hijacked by some other items so I have not yet tried these solutions.

     

    I'm hoping to try this out tomorrow. Will revent then.

     

    Thanks