Forum Discussion
Translating Table with translation key
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!
2 Replies
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
Hi, elam91
Please check this example. This is just one simple option to get values from other table without connecting them.
