Forum Discussion

eriku's avatar
eriku
Regular Visitor
3 years ago
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, ...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

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

     

    In DAX

     

    Switch([Status],

    0, "Open",

    1, "Won",

    2, "Closed"

    )

     

eriku's avatar
eriku
Regular Visitor
3 years ago

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?