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] )
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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)