Clarification in Treatas

[tsraaj]

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

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

Hope this helps.

[lbendlin]

That's not what TREATAS is for.  You are looking for a DISTINCT(UNION()) function or similar.