Create Date Table with Dynamic Language in Power Query

[@wayneedmondson1065]

Awesome! Thanks for walking through the steps. Thumbs up!!

[@BIGorilla]

Thanks Wayne, really glad you liked it!

[@GrainneDuggan_Excel]

Thanks for the clear and thorough explanation, Rick!

[@BIGorilla]

Thanks Grainne, it's an interesting topic that put different concepts together. Hope this helped!

[@ExcelInstructor]

@@BIGorilla Hi Rick, 9:57 a question here, in your Parameter you already have the exact same selectable Values as in the Table with language encoding so in Correct me if im wrong: tha language encoding Table can contain unique Values only, so if you would filter that Table by your parameter, then you will always get 1 row result, whch you can reference AS {0} to get the record and then use [EncodingColumn] to get to that specific text of en-EN or nl-N, isnt that as robust method as your but easier to read?

[@ExcelInstructor]

What about using some dictionary API to translate words using some dictionary? Would that be possible? I tried playing around with APIs and translating but i was not able to make it work :(

[@Bhavik_Khatri]

Very nice tutorial.

[@BIGorilla]

Thanks Bhavik. Hope you learned something new 🚀✔

[@NMVJ]

Excellent Rick :)

[@BIGorilla]

😍 Thank you very much. You can copy the code on how to approach this in the written blogpost.

[@ssomtom]

Awesome. Thx

[@BIGorilla]

Great to hear you liked it!

[@ricardorzm]

Very nice! So, you say that if I build this before creating relationships and measures, it won't break? For example, if I create a visual that references one of the translatable columns, when I change the language, it won't break and throw an error that a column can't be found? Thanks again!

[@Iloveyou0600]

Thank you for this! Super cool video! A+++

[@BIGorilla]

Wow wow, glad to provide it ! 🙌🏻

[@andreadoro9731]

Hi everybody, i want to ask if there is a way to renaming dynamically as in this video, but for column that are 'normal' and are not date, is it possible? thank you

[@ExcelInstructor]

and recently you showed how to connect to APIs can you maybe help with translating words from a Table based ona language column using API in the 3rd column?