The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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
team Please help.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |