The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
we want to convert amount to words along with decimals.
Ex.
INR 50.25 = Fifty rupees and twenty five paisa
USD 50.25 = Fifty dollars and twenty five cents
this should be inline with CCY like lakh, crore for INR .. million, billion for USD (as applicable)
Thanks for Advance
Hey, I think you can refer to
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Displaying-Numbers-in-Words/m-p/1280892
After making 2 measures, you can use if statement to return between IND and USD.
I need to convert decimal also ..without decimal above url will be work,..plz suggest me any code for decimal conversion also
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |