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 important ones.
Another one is the Rate and PMO Location
and the last one will be the Project: Which contains PMO Location, Project Name and others.
What he is trying and I couldnt succed was to create a new column ON PROJECT that its formula will be Rate*Hours
Rate is on the Rate table and Hours in the Time table.
I wasnt able to do so.
Any help will be appreciated.
Table data below
It seems the relationships created where good and so on. Any help/explanation will be of great help.
Thank you all
This should work for you:
SUMX ( RELATEDTABLE ( 'Time' ), 'Time'[Hours] ) * RELATED ( Rate[Rate] )
Hope this helps
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021