Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

we want to convert amount to words along with decimals in Power BI Report

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 

 

 

2 REPLIES 2
colacan
Resolver II
Resolver II

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.

Anonymous
Not applicable

I need to convert decimal also ..without decimal above url will be work,..plz suggest me any code for  decimal conversion also

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.