Data Conversion

[adhishvellore]

Hi all,

I have a problem with data conversion. For example i want to translate the data from PBI Data Set (cannot edit as owned by someone else) - so transform data option doesn't work, but i am assuming there should be a way using DAX code (which i am not familiar with).

The table is as below: Simply put the power bi data set shows data in codes which not everyone is familiar with. So, i need to have a way to translate that into different names as below. Anyone please can guide me. I do not want to have any changes to the main data....much appreciate your help.

Thanks in advance.

Area Code	Area Name
A1	India Subcontinent
B1	North Asia
C1	Mainland China
D1	South Asia

[v-alq-msft]

Hi, @adhishvellore 

The connectivity mode for Power BI dataset is live connection. No data is imported into the Power BI store. Instead, upon building a visual within Power BI Desktop, queries are sent to the underlying data source to retrieve the necessary data.

For further information, please refer to the following documents.

Connect to datasets in the Power BI service from Power BI Desktop 

Best Regards

Allan

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@adhishvellore , If the dataset is power bi, you are not allowed to create a new column. So you can create a measure but that you can not use in the filter

measure =

Switch(True() ,

[Area code] = "A", "India Subcontinent',

//add other

)

[adhishvellore]

@amitchandak . Thanks for your prompt reply. If i cannot display the translated value as a filter, then i guess not worth doing it 🙂. But i tried the given code and it's not even allowing me to select "Area Code" from the data set. Do you know why?

Cheers

Adhish