Forum Discussion

mpapreja's avatar
mpapreja
New Member
4 years ago
Solved

Custom Number Format for the Numerical Fields in Power BI

Dear Experts   Thanks for your support in advance.    Can i use following format in Power BI which works in excel   [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0    
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  mpapreja ,

    Here are the steps you can follow：

    1. Create calculated column.

    Column =
IF([Column1]<10000000,
","&MID([Column1],LEN([Column1])-6,2)&","&MID([Column1],LEN([Column1])-4,2)&","&RIGHT([Column1],3),
LEFT([Column1],LEN([Column1])-6)&","&MID([Column1],LEN([Column1])-4,2)&","&RIGHT([Column1],3))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  mpapreja ,

Here are the steps you can follow：

1. Create calculated column.

Column =
IF([Column1]<10000000,
","&MID([Column1],LEN([Column1])-6,2)&","&MID([Column1],LEN([Column1])-4,2)&","&RIGHT([Column1],3),
LEFT([Column1],LEN([Column1])-6)&","&MID([Column1],LEN([Column1])-4,2)&","&RIGHT([Column1],3))

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly