question

MajumderManish-0895 avatar image
0 Votes"
MajumderManish-0895 asked MajumderManish-0895 commented

How to merge tables in Azure Analysis Services Tabular Model

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?

azure-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MajumderManish-0895 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered MajumderManish-0895 commented

Hello @MajumderManish-0895 ,
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



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,
Thank you so much.
The Solution shared works perfectly for me.
Regards
Manish

0 Votes 0 ·