Combine two tables price/equipment

[trndlnd]

Hi,

I have created a Power BI report that shows when employees take out new equipment at work and when they do it. Data is retrieved from a CSV table online (from another system). This view works fine.

I also want to show the cost for each department, so I have created a separate table that contains the name of the equipment and the price per unit. The name of the different equipment the equipment matches with the CSV table.

How can I get these two forms to connect so that I get the total price per department and can sort by different equipment.

Is this what is called a look up table?

Screenshot from the csv table.

"AvdID" is department ID. "AvdelingUtstyr" is the name of the department. "UtstyrType" is the name of the equipment. "UtlevertDate" is the date the equipment is picked up.

Screenshot from the price table

"UtstyrType" is the name of the equipment (same as the table above.

"Pris" is the price of the equipment.

I guess there is an easy fix to this but I just can't see it right now.

Thanks for any help!

[Idrissshatila · Accepted solution]

Hello @trndlnd ,

then you need to merge queries and get the price to he first table by the equipment name.

https://learn.microsoft.com/en-us/power-query/merge-queries-overview