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 all,
Currently, I am working on one dashboard and I would like to ask you for some help for it because I tried a lot of things but still can't figure out how to make it better for this question we can assume that I have 2 tables.
In Table 1 I have information about the working hours of each role, for each project each month, etc.
In Table 2 I have the capacity of each function for each month
In the photo below, I placed information from dashboard tables, in Table 3 you can see that this table is just a summary of Table 1 for each month and each function. My task is now to subtract Table3 values from values in Table 2 based on month and function value. Also if I select "Priority" form the first table I would like to subtract only values with that "Priority".
Any ideas on how to make it or I want too much from Power Bi? 😄
Solved! Go to Solution.
You can merge table1 and table2 using anti join. In query editor, click "Merge queries" and select anti join.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can merge table1 and table2 using anti join. In query editor, click "Merge queries" and select anti join.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |