I need a DAX expert
$10-30 USD
货到付款
I am a newish data engineer. I am learning the DAX language for Power Bi. I need one table to "LOOKUP" a value from another table based on a few things. There is no relationship between the tables and they come from different sources.
WHAT I NEED: I need a DAX code in the "MasterData" table (in the calculated columns) that say, (If item number is not empty then match the item number from this table to the item number in the "LookupInfo" table and bring back the "ProductLine" for that item number, otherwise, match the item descriptions to bring back the "Product Line", if both are blank then say "none". and then again for Entity...which I assume will be the same exact code just plug in the other names.
项目ID: #19594666
关于项目
授予:
Hi, Combine the two tables with full outer join and remove duplicates from the final table. Send me your data or sample data I will complete it today. Thanks
有3名威客正在参与此工作的竞标,均价$28/小时
Hi. My name is Jordi Aguinaga from Mexico and I'm a BI professional with over 14 years of experience. I have been working with Power BI for a couple of years now and I think I can help you with your requirement. 更多