Forum Discussion

MMoll's avatar
MMoll
Frequent Visitor
4 years ago
Solved

Difference between values from two different tables, on and a Lookup value from another table

I have a list of whatsits (under NDA, so obfuscating source data), each with an assigned "level" and large number of parameters that have to meet certain minimum requirements for that level. The requ...
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, MMoll 

    Try calculated columns as below:

    Requirement A = LOOKUPVALUE( Requirements[Parameter A],Requirements[Level],Data[Current Level])
    Result_A = IF(Data[Parameter A]<Data[Requirement A],TRUE(),FALSE())

    New fields used to conditional formatting:(Format style:Rules)

    Conditionalformatting_A = 
IF(Data[Parameter A]<Data[Requirement A],1,0)

    or (Format style: Field value)

    Conditionalformatting_A = 
IF(Data[Parameter A]<Data[Requirement A],"#FF0000","#000000")

    Result:

    Please check my sample file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, MMoll 

Try calculated columns as below:

Requirement A = LOOKUPVALUE( Requirements[Parameter A],Requirements[Level],Data[Current Level])
Result_A = IF(Data[Parameter A]<Data[Requirement A],TRUE(),FALSE())

New fields used to conditional formatting:(Format style:Rules)

Conditionalformatting_A = 
IF(Data[Parameter A]<Data[Requirement A],1,0)

or (Format style: Field value)

Conditionalformatting_A = 
IF(Data[Parameter A]<Data[Requirement A],"#FF0000","#000000")

Result:

Please check my sample file for more details.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.