The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
55 | |
47 | |
47 |