Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Substract values from a column in a different table

Hi,

I have a calculated column which contains the available hours multiplied by 40 (AvailableHours). Now i need to subtract the values from a column that's in a different table with the AvailableHours column. 

 

Any clues how to accomplish this? 

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on your description, I think you could try "LookupValue()" function. Here is my test table.

    create a column

    Column =
[V1] - LOOKUPVALUE ( 'T2'[V2], T2[Type], 'T1'[Type] )

    Result:

    Or you could try to crossjoin two tables.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    Anonymous 

    could you please provide sample data and expected output?

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Based on your description, I think you could try "LookupValue()" function. Here is my test table.

    create a column

    Column =
[V1] - LOOKUPVALUE ( 'T2'[V2], T2[Type], 'T1'[Type] )

    Result:

    Or you could try to crossjoin two tables.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.