Forum Discussion

mbrawn's avatar
mbrawn
Frequent Visitor
8 years ago
Solved

Cross-Table Calculation

Hi there,   I am after some help with an issue I have performing a simple calculation across 2 tables. I have the following relationship set up between these 2 tables:     This is allowing...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    mbrawn

     

    Hi, are you already try with:

     

    New calculated column:

     

    TotalHoursSpent = CALCULATE(sum(Table2[HourSpent]))*105

     

    Regards

     

    Victor

    Lima - Peru

     

     

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

mbrawn

 

Hi, are you already try with:

 

New calculated column:

 

TotalHoursSpent = CALCULATE(sum(Table2[HourSpent]))*105

 

Regards

 

Victor

Lima - Peru

 

 

mbrawn's avatar
mbrawn
Frequent Visitor
8 years ago

Vvelarde

 

You hero! Thank you, that has given me exactly what I need.

 

Thank you.