Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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
Proud to be a Super User! | |
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
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |