Forum Discussion

kralco626's avatar
kralco626
Frequent Visitor
8 years ago
Solved

Calculate between many to many tables

I have 3 tables with a many to one and then one to many relationship.     Cost Rates: This table has different types and pieces of an hourly cost rate. The user would need to select what ra...
Need Help
  • kralco626's avatar
    kralco626
    8 years ago

    Well, I have been posting on programming help forums like this one for over a decade now. And I know the rules... Always google your problem before posting it. Well, I have been googling and working on this problem for over a week, so I decided to post it.

     

    But, after posting I decided to do just one more google search. Well, I found an article that explained how to use SUMX and I think it is doing exactly what I need it to do.

     

    All I did from my above example was change the Cost measure to:

    Cost = sumx(Hours,Hours[CR_HRS] * [Cost Rate]) 

     

    It seems to work, I'll have to use it in my full, more complex dataset to be sure, but it seems right, unless someone has another idea?

kralco626's avatar
kralco626
Frequent Visitor
8 years ago

Well, I have been posting on programming help forums like this one for over a decade now. And I know the rules... Always google your problem before posting it. Well, I have been googling and working on this problem for over a week, so I decided to post it.

 

But, after posting I decided to do just one more google search. Well, I found an article that explained how to use SUMX and I think it is doing exactly what I need it to do.

 

All I did from my above example was change the Cost measure to:

Cost = sumx(Hours,Hours[CR_HRS] * [Cost Rate]) 

 

It seems to work, I'll have to use it in my full, more complex dataset to be sure, but it seems right, unless someone has another idea?