How to merge tables in Azure Analysis Services Tabular Model

Question

I have a requirement to do inner join merging of 2 tables and then use the merged table to do inner join with the other table.
It is although very easy to do in PowerBI transformation , however i cant find the same option in AAS?
May i please know how to achieve that in AAS?

Answer 1

Hello @Majumder, Manish ,
Thanks for the ask and using the Microsoft Q&A platform .
I think you can use the DAX command LOOKUPVALUE and get this resolved . I request you to please review the below thread .

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8f9964f7-e985-479f-a769-35d3d4d8a288/how-can-i-merge-2-tables-data-and-add-appropriate-columns-in-ssas-tabular-model?forum=sqlanalysisservices

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members