Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have two tables:
Table A
Driver_Name ,Date , total_order
Table B
Driver_Name,Date ....
Now i want to i want to insert the value from table A when driver name and date are matched.
What should i do for this?
Solved! Go to Solution.
Hi @Anonymous,
You could add a calculated column in Table B via Lookupvalue funcion.
New Column = LOOKUPVALUE ( TableA[total_order], TableA[Driver_Name], TableB[Driver_Name], TableA[Date], TableB[Date] )
Best regards,
Yuliana Gu
Hi @Anonymous,
You could add a calculated column in Table B via Lookupvalue funcion.
New Column = LOOKUPVALUE ( TableA[total_order], TableA[Driver_Name], TableB[Driver_Name], TableA[Date], TableB[Date] )
Best regards,
Yuliana Gu
I tried to use your formula but for some reason my tableB cannot be enterred/recognised. Any suggestions?
Thanks
Here it worked. The tables have to be related by some column
Hi @Anonymous
use Power Query "Merge Queries"
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
User | Count |
---|---|
141 | |
71 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |