New measure or column for each line subtaction based on values and functionality to scile data

[MantasLukauskas]

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? 😄 

[v-yuta-msft · Accepted solution]

@MantasLukauskas ,

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.