Value should be in word

[prinuce]

Hi BI family, 

I need a help from you. I have a Net pay salary column in my table. that can be change each month.

I want this value in word and this value can change every month its dynamic. It will change every month. Please help me.

Net Pay Salary	Salary in word
5000
9550

[Samarth_18]

Hi @prinuce ,

You can refer below thread to get your Salary as word. 

 https://community.powerbi.com/t5/DAX-Commands-and-Tips/Displaying-Numbers-in-Words/m-p/1280892 

Just replace "ParameterNumber[ParameterNumber Value]" with your column in accepted answer.

Thanks,

Samarth

[Anonymous]

1.Using Edit Query follow below steps-

step 1- right click - edit query

step 2 - in edit query window, select the column

step 3- Transform Data

step 4 - click on DATA Type - select Text

step 5 - you can select replace current or add new step

[prinuce]

@amitchandak Sir

[prinuce]

team Please help.