Forum Discussion
Solved
Converting numbers to text
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 , You have to create a new column in the power query of DAX
In DAX
Switch([Status],
0, "Open",
1, "Won",
2, "Closed"
)
2 Replies
eriku , You have to create a new column in the power query of DAX
In DAX
Switch([Status],
0, "Open",
1, "Won",
2, "Closed"
)
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?
