Is it possible to somehow multiply fields from two different data sources

[mbabayigit]

I connected power BI with an sql Server and an easy Excel sheet. 

Can I somehow create a measure (or whatever I have to use for this case) to multiply a column from the Excel sheet with a column from the sql query.

This is the case:

I want to know how much Service we generate with a special managed service article per month/year.

So from the sql query i get the information how often we sold the article (quantity) and in the excel sheet we noted how much service is in this article (in Euros). (The managed Service article is composed of service and software for example), thats why i seperated the service into the excel sheet.

in both sources i have the item number, so i have an information to connect the sources with each other.

What do I have to do (with DAX language?) to multiply the quantity with the Euro from each source so it is seperated on each item number.

I hope I have explained it understandably.

Thanks in advance

[mbabayigit]

thank you very much, that helped 🙂

[johnt75 · Accepted solution]

If there is only 1 entry in your Excel sheet for each item number then you can create a one-to-many relationship between that table and the table from SQL. You could then create a new calculated column on your SQL table like

Quantity * Service = 'Sales'[Quantity] * RELATED('Items'[Euros])