Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Folks,
I have a 2 columns from 2 different tables and need to get same items from both and sum of them
As filter, I need to add conditions, where code are same, but CodeName is little different
How can I realize it?
Hi,
are the first 4 letters unique for each Code Name and identical in both tables? And what does the connection between the tables look like?
Code 4 letters is same for both, but codename may be different for the same Code. Connection is Many to One
Maybe try something like:
Measure =
VAR CodeTab1 = LEFT(MAX(Table1[Code Name]), 4)
VAR CodeTab2 = LEFT(MAX(Table2[Code Name]), 4)
RETURN
if(CodeTab1 = CodeTab2, SUM(Table1[Value]) + SUM(Table2[Value]), BLANK())
it always shows blank