How to merge different tables in model

[sivarajan21]

Hi,

Below is our raw data ss and this is how originally it looked like before we unpivoted them to separate columns for Data Electricity,Site,Batch,Client group:

Is it possible to merge DataElectricity, Data General and Data water table with communications table shown in below image?

Can we do it using dax, power query etc?

If so, can you please guide me through how to do it?

PFA file Communications (2).pbix

Please let me know if you need further info.

Thanks in advance!

@Ahmedx @Greg_Deckler @grantsamborn @Ashish_Mathur @amitchandak 

[sivarajan21]

Hi,

Thank you! But I am looking to merge these tables using dax measures!
Can you please guide me through?

Thanks in advance

[Idrissshatila]

@sivarajan21 ,

you could do this using lookup value function.

check it out https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Idrissshatila · Accepted solution]

Hello @sivarajan21 ,

check this video to see how to merge tables in power query

https://youtu.be/rYwnkcaUDtc?si=PuzqZOw8Yc9Kx5eK

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡