Converting numbers to text

[eriku]

Hello!

Background:

I am using Dynamics 365 data, primariliy opportunity data - the opportunity statuses include open, won, and lost. The issue I'm having is that these values appear as 0, 1, and 2 in Power BI. 

I am familiar with navigating Power BI (e.g., data transformation, relationship management, etc.,).

Is there a simple solution to this problem?

Thanks!! 

[eriku]

Thanks for the response.  I'm not familiar with DAX. I am trying to figure it out now. Is DAX built in or is a third-party application/tool?

[amitchandak · Accepted solution]

@eriku , You have to create a new column in the power query of DAX

In DAX

Switch([Status],

0, "Open",

1, "Won",

2, "Closed"

)