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.
I have 3 tables:
1. company (company_id, name, adres, etc..)
2. quotes (quotes_id, company_id, value, project_number etc..)
3. orders (orders_id, company_id, value, project_number)
The tables are 1 to many connectect through company_id
Table 2 quotes:
quotes_id | company_id | value | project_number |
1 | 55 | 100 | 20201 |
2 | 55 | 10 | 20202 |
3 | 57 | 2000 | 20203 |
4 | 58 | 20 | 20204 |
Table 3 orders:
orders_id | company_id | value | project_number |
1 | 55 | 100 | 20201 |
2 | 57 | 2000 | 20203 |
3 | 53 | 25 | 20208 |
4 | 58 | 300 | 20209 |
I want to formulate a DAX formule which counts the value of de orders (order[value]) but only from project number (orders[project_number]) that don't exist in de quotes table (quotes[project_number])
So in this case the result should be 25 + 300 = 325.
please help.
Solved! Go to Solution.
First thing: create a calculated column in the Order table as follows:
First thing: create a calculated column in the Order table as follows:
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |