Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
tsraaj
Frequent Visitor

Clarification in Treatas

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 :

NameDivision
name 1a
name 2a
name 3b

table 2 : 

NameAmt
name121
name220
name 421
name110

 

Now im getting result for TREATAS

namesum of amt
name131
name220
name30

 

But i need below result

namesum of amt
name131
name220
name30
name421
1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

Download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.