Forum Discussion

Helper I

3 years ago

Getting the column sum when multiplying with another table.

Hi, I have two tables and I'm using DAX to multiply a column from table1 with a column from table2. The two tables are connected by a key so it is multiplying per row (the key is built on Group a...

Need Help

FreemanZ

Super User

3 years ago

hi JohannesM

it needs both columns to find the unique match.

Actually you can use Merge Query in Power Query, by bring the Table1[Cost] column to Table2. Ensure to select both the group and year in merging. Check this:

https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9#:~:text=In%20the%20Merge%20popup%20window%20%20-%20Choose,whether%20you%20need%20to%20make%20...%20See%20More

JohannesM

Helper I

3 years ago

Hi FreemanZ
But isn't that what I already do with the relation in PBIs "Model"-page? RowID in the picture below is based on Group and Year to get that unique match.

Forum Discussion

Getting the column sum when multiplying with another table.

Related content

Transform Multiple columns by multiplying by another column

multiplier

PowerBI Desktop Get dataflow gen1 data from another tenant

Get first date a value from another column exists

Multiply column values depending values from another column