Multiply column by standard rate

[michaleczuszek]

Dears,

I have two tables. First is sales data divided by months, years, and countries. Second table is country with standard multiplier. I have to multiply sales data from first table by standard multiplier from second table. Each month from first table has to be multiply by standard multiplier from second table. Both tables can be linked only by country. 

Issue is if i merge both tables by country and i simple create measure to multiply sales by multiplier, multiplier is sum and i get totally wrong result.

Thank you

Michal

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[AlB]

Hi @michaleczuszek 

Can you show a sample of your tables and explain what you need with an example based on that data?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers