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,
I would like to calculate a sum of two data sets that are non related- what is the best practice for this. Should I do this in Dax or in SQL?
The tables come from two different data sets- in one case a roster and then one case a recruiting system where they are candidates
How do i add both East up into one chart so that I can get 3?
In excel i would filter the data from each set and then add the two cells.
Here is an example
Employee Roster | |||||
Employee | Division | Hire Type | Sale Type | Month Hired | Quarter |
A | East | Internal | Seller | 1 | 1 |
B | East | External | Mgr | 2 | 1 |
C | East | External | Seller | 3 | 1 |
D | East | External | Seller | 4 | 2 |
E | West | External | Seller | 5 | 2 |
F | East | External | Seller | 6 | 2 |
Pivot table
Hire Type | External |
Sale Type | Seller |
Quarter | 2 |
Division | Count of Candidate |
East | 2 |
West | 1 |
Grand Total | 3 |
Data set 2- candidate information
To be Hired | ||||||
Candidate | Division | Hire Type | Sale Type | Hiring Status | Month Hired | Quarter |
G | East | Internal | Seller | Offered | 1 | 1 |
H | West | External | Mgr | Sourced | 2 | 1 |
I | East | External | Seller | Hired | 3 | 1 |
J | East | External | Mgr | Offer Accepted | 4 | 2 |
K | West | Internal | Seller | Future Start | 5 | 2 |
L | East | External | Seller | Future Start | 6 | 2 |
Pivot Table
Hire Type | External |
Sale Type | Seller |
Quarter | 2 |
Hiring Status | (Multiple Items) |
Row Labels | Count of Employee |
East | 1 |
Grand Total | 1 |
Solved! Go to Solution.
Hi @anthlen,
According to your description, you want to combine two datasets so that you can sum the total value from each dataset, right?
You can achieve this in Query Editor mode.
1. Filter rows for each table.
2. Append two tables as a new single table.
3. Pivot the new table.
Regards,
Yuliana Gu
Hi @anthlen,
According to your description, you want to combine two datasets so that you can sum the total value from each dataset, right?
You can achieve this in Query Editor mode.
1. Filter rows for each table.
2. Append two tables as a new single table.
3. Pivot the new table.
Regards,
Yuliana Gu
Hi,
You can use measures, use the calculate function to get the data from each table 😄
Each table has different filters on it.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |