Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

column dynamic language translation

Hi, we have the following dataset, in this dataset there are months in different languages, these should be translated into German if possible.     A quite simple implementation is possible...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    If you want to use DAX function to achieve it, you need to create a Table including different months from different regions, and a Germany month column like this:

    Then you can create a calculated column in the source table to 'translate' the month column:

    Germany month translation =
IF (
    'Table'[Month] IN DISTINCT ( 'Month'[Germany month] ),
    [Month],
    LOOKUPVALUE ( 'Month'[Germany month], 'Month'[Month], 'Table'[Month] )
)

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

If you want to use DAX function to achieve it, you need to create a Table including different months from different regions, and a Germany month column like this:

Then you can create a calculated column in the source table to 'translate' the month column:

Germany month translation =
IF (
    'Table'[Month] IN DISTINCT ( 'Month'[Germany month] ),
    [Month],
    LOOKUPVALUE ( 'Month'[Germany month], 'Month'[Month], 'Table'[Month] )
)

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.