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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
0970
Frequent Visitor

DAX有函數可以將數值轉換成中文大寫

1680246399664.jpg

 

EXCEL可以TEXT(1234567890,"00億0000萬0000元")會呈現12億3456萬7980元

Power BI DAX可以嗎?

1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

尝试这个:

Measure 45 = FORMAT(MAX('Table (29)'[Column1]),"00億0000萬0000元")
 
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
 
ValtteriN_0-1680247452494.png




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ValtteriN
Super User
Super User

尝试这个:

Measure 45 = FORMAT(MAX('Table (29)'[Column1]),"00億0000萬0000元")
 
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
 
ValtteriN_0-1680247452494.png




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




謝謝,你真棒👍👍

1680248805320.jpg1680248838223.jpg

 

 

 

 

 

 

 

請問12億3456萬7980元,可以一步一步現>>12億3 , 456萬7 , 980元1680248968138.jpg

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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