Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I will get value from table 2 to table 1 using TREATAS. TREATAS get values if both calumn value same. but i need, values not have in table 1 but value have in table 2 for compared columns. Now how to get this calumn value.
@treatas
table 1 :
Name | Division |
name 1 | a |
name 2 | a |
name 3 | b |
table 2 :
Name | Amt |
name1 | 21 |
name2 | 20 |
name 4 | 21 |
name1 | 10 |
Now im getting result for TREATAS
name | sum of amt |
name1 | 31 |
name2 | 20 |
name3 | 0 |
But i need below result
name | sum of amt |
name1 | 31 |
name2 | 20 |
name3 | 0 |
name4 | 21 |
Solved! Go to Solution.
Hi,
Download my PBI file from here.
Hope this helps.
Hi,
Download my PBI file from here.
Hope this helps.
That's not what TREATAS is for. You are looking for a DISTINCT(UNION()) function or similar.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
108 | |
92 | |
67 |
User | Count |
---|---|
161 | |
129 | |
129 | |
92 | |
91 |