Forum Discussion
2 tables, problem with multiple cardinalitiy
Hello,
I have two tables, each with the same Column Names, with the only difference being the time of data extraction for each table (one week appart).
"Planned" table shows Planned time and "Real" table shows Real time submitted by actual resources in the spam of a week.
I need to compare, for each resource, the time they had planned VS. the real time they actually sumbited. Pretty simple, yet I'm having problems.
Underlined in red are the project codes, which are the same in both tables and which I use as a relationship.
Underlined in blue, are the "Real" and "Planned" time columns, which I am trying to compare.
Here is the result, with the names blocked.
Here, if I use the "Resource" variable from the "Real" table, then the sum of the "Real" time for each resource is good, but that of the "Planned" time is false.
On the other hand, if I use the "Resource" variable from my "Planned" table, then the "Planned" time will be good and the "Real" time will be bad. Here is an example:
I've looked around but can't seem to find an ideal solution for my problem. I am sure there is one though, considering that what I'm trying to achieve is a fairly simple table.
Does anyone have a clue ?
1 Reply
- amitchandak
Super User
JacobMartin , better to have common tables like Date, Resource, project, plan etc and analyze data using common dimensions
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda