Forum Discussion
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 ...
Vicky_Song
Impactful Individual
Impactful Individualaandrade21, 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
Administrator
AdministratorCalculated 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.