Translating Table with translation key

[elam91]

Hi, I have a table which is completely in arabic, and I have a table with 2 columns, one is every value and column name in arabic, and the second colum is their translation, I want to create a new table that takes table1 and translates every single thing using the translation table. Is there an easy way to do this? 

Thank you in advance!

[ALLUREAN]

Hi, @elam91 

Please check this example. This is just one simple option to get values from other table without connecting them.

https://www.dropbox.com/s/p9kk4upg4elmmay/Translating%20Table%20with%20translation%20key%28allure-an...

[Greg_Deckler]

@elam91 I read through that 2 or 3 times and still not completely certain what you want exactly. So, are you trying to translate the data in the table or the columns names themselves or ? I wrote a 4 part blog article on translations.

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-1/bc-p/2065057

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-2/ba-p/2065547

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-3/ba-p/2071522

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-4/ba-p/2095284