How to Group by & Merge new column into one-side table in one-to-many relationship by DAX?

[TungNguyen_19]

Hi everyone,

I have these 2 table:

I want to add ['Amount in loc.curr.2'] from table 'SAP Revenue CMSVN' into table 'M Import'.

These 2 tables have relationship one-to-many so I can not use RELATED function.  I found that there is GROUP BY function but I don't know how to combine it with ADDCOLUMNS or any function like that⁉️

I know this can do very simple in Power Query but I have to implement this by DAX 😥
How to do this in DAX? Please help me, many thanks to you guys ❤️

[DOLEARY85]

Hi,

try adding a calculated column to M Import using the DAX:  RELATED('SAP Revenue CMSVN'[Amount in loc.curr.2])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[TungNguyen_19]

I can not use RELATED on many side in one-to-many relationship