<div>
This is in Microsoft Power BI application. It doesn't offer the format option when I right click and your new formula doesn't work either.<br />
It uses DAX if that helps.<br />
&nbsp;I'm not familiar with DAX.
</div>


This is in Microsoft Power BI application. It doesn't offer the format option when I right click and your new formula doesn't work either.
It uses DAX if that helps.
 I'm not familiar with DAX.

<div>
Ooops you answered me before I posted !!! how this can be ?<br />
gowflow
</div>


Ooops you answered me before I posted !!! how this can be ?
gowflow

<div>
Now it won't let me do a SUM on that field?????
</div>


Now it won't let me do a SUM on that field?????

<div>
Never mind I figured it out!
</div>


<div>
Have you tried using ROUND?<br />
<br />
Miles = ROUND((KOB1[Cost]/.535),2)<wbr />
</div>


Have you tried using ROUND?

Miles = ROUND((KOB1[Cost]/.535),2)

<div>
<div class="content wysiwyg-content">
I have a PBI table and I created a new column with the following formula<br />
<br />
Miles = (KOB1[Cost]/.535)<br />
<br />
I need it to show only to two decimals.<br />
<br />
Example:<br />
<br />
Current: &nbsp;45.654897215<br />
<br />
Desired: &nbsp;45.66
</div>
</div>


I have a PBI table and I created a new column with the following formula

Miles = (KOB1[Cost]/.535)

I need it to show only to two decimals.

Example:

Current:  45.654897215

Desired:  45.66

PBI - need to format a new column with formula

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.