Forum Discussion

aandrade21's avatar
aandrade21
Regular Visitor
10 years ago

How to Multiply Two or Three Fields

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!!!

Need Help

2 Replies

  • Vicky_Song's avatar
    Vicky_Song
    Impactful Individual
    10 years ago

    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's avatar
      GuyInACube
      Administrator
      10 years ago

      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.