Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Tabe: Time
Hours | # of PMOResources | Period | Project |
300 | 5 | September 2017 | Apollo |
42 | 1 | October 2017 | Apollo |
3 | 1 | November 2017 | Apollo |
28 | 1 | December 2017 | Apollo |
33 | 1 | January 2018 | Apollo |
91 | 3 | February 2018 | Apollo |
68 | 3 | March 2018 | Apollo |
64 | 2 | April 2018 | Apollo |
22 | 1 | May 2018 | Apollo |
72 | 3 | January 2018 | Aries |
54 | 2 | February 2018 | Aries |
63 | 2 | March 2018 | Aries |
61 | 2 | April 2018 | Aries |
38 | 1 | May 2018 | Aries |
53 | 2 | February 2018 | Gemini |
29 | 1 | March 2018 | Gemini |
15 | 1 | April 2018 | Gemini |
100 | 4 | May 2018 | Gemini |
200 | 3 | August 2017 | Leo |
50 | 1 | September 2017 | Leo |
83 | 2 | October 2017 | Leo |
19 | 1 | November 2017 | Leo |
57 | 2 | December 2017 | Leo |
85 | 1 | August 2017 | Orion |
75 | 1 | September 2017 | Orion |
19 | 1 | April 2018 | Pegasus |
60 | 3 | May 2018 | Pegasus |
48 | 2 | May 2018 | Taurus |
100 | 2 | June 2017 | Titan |
Tabe: Rate
PMO Location | Rate |
APAC | 80 |
EMEA | 90 |
LATAM | 100 |
NA | 110 |
Tabe: Project
Project Name | Project Manager | Project Start Date | Project Finish Date | PMO Location |
Apollo | Bob | 9/13/2017 | APAC | |
Aries | Bob | 1/4/2018 | EMEA | |
Gemini | Tim | 2/18/2018 | EMEA | |
Leo | Sally | 8/28/2017 | 12/30/2017 | LATAM |
Orion | Tina | 8/15/2017 | 9/30/2017 | LATAM |
Pegasus | Sally | 4/4/2018 | NA | |
Taurus | Angie | 5/1/2018 | NA | |
Titan | Tina | 6/1/2017 | 6/30/2017 | APAC |
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:
Cost = SUMX ( RELATEDTABLE ( 'Time' ), 'Time'[Hours] ) * RELATED ( Rate[Rate] )
Hope this helps
David
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |