Forum Discussion

pipechaves's avatar
pipechaves
Frequent Visitor
9 years ago
Solved

Need Help- Relationships and formulas

Hi members,   I need some advice. As today I got a really strange issues from a fellow. He got 3 tables. One contains the Project Name, Total Hours and other fields. I will just mention the i...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    pipechaves

     

    Hi, Friend, try with this calculated column

     

    Rate*Hours =
CALCULATE ( SUM ( 'Time'[Hours] )
    * RELATED ( Rate[Rate] )
pipechaves's avatar
pipechaves
Frequent Visitor
9 years ago

it seems that might work.

 

Do you mind explaining why the use of related and so on insted of doing it directly ?

 

Thank you

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

pipechaves

 

The RELATED function returns to you a value from another related table.

 

So in this case you want the Rate from RateTable (From One to Many) and the function search (or Look) the Row with the coincidence according to the Key of the relationship (PMO Location)