How to Multiply Two or Three Fields

[aandrade21]

Hello, I'd like to figure out how to do some very basic functionality. 

I have a CRM and have all of the field below in the screenshot in my CRM.

-Annual Volume, Piece Price and Commision Rate are all fields that I need to manually enter information into. 
-Estimated Annual sales is calculated by multiplying Annual Volume by the Piece Price. 
-Commision Revenue is calculated by multiplying Estimated Annual Sales by Commission Rate. 

Knowing all that, how can I create the table to multiply and spit out those two values that I need automated above (Estimated Annual Sales and Commision Revenue)

I basically want PowerBi to replicate the excel file table I screenshotted below. 



Any help would be much appreciated! I feel like these things are strightforward but I can't find an easy solution. 

Thank you!!!

[Vicky_Song]

@aandrade21, you're able to connect to CRM with Get Data -> Microsoft Dynamics CRM Online. With it, the columns are imported into Power BI. 

You are also be able to create calculated columns if you would like to add/edit fields. Please check this article for the details. 

[GuyInACube]

Calculated column is the way to go. You can't do that if you pull the data in via the Get Data experience as you can't modify the dataset/model. 

You would have to do as Vicky suggested and pull the data into either Power BI Desktop or Excel.