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?