Create a Calculated Field/Column in Dataverse to use with Power Apps or Dynamics 365

Calculated fields/columns can be used to do math with your data in Power Apps or Dynamics 365.

In this hands-on tutorial, I’ll show you how to build a new calculated field/column from scratch (using the Opportunity table in the Dynamics 365 Sales app), how to add it to a form, and then how to test that it’s working.

00:00 – Overviewing the completed calculated field/column in the Dynamics 365 Sales app
01:44 – Creating a new calculated field/column
04:33 – Adding a new calculated column/field to a form
05:43 – Testing the calculated field/column

[TinyTechnicalTutorials]

What else do you want to learn about Power Apps/Dynamics 365? Let me know below in the comments!

[developermct]

I need a string type of calculated field. I need to concatenate text from more than one field. It doesn't seem to like "&" or "+" to splice the strings. How do you do this? Thanks!

[aleksandratrpeska]

Hi, was just curious if the Opportunities table is part of the sample data, or was made in one of the other videos, because I don't seem to find it

[rodrsturge]

Thanks for the video. In a model driven app, where would you do more complex calculations: For example in order to provide a view where people haven't completed their assignment this quarter? (The calculated field only allows you to check a date against a hard coded date)

**Edit** I see you can create a table column of type 'fx Formula' which allows you to input more complex calculations. For example Quarter of AssignedTask:

"Q" & Text(RoundUp(Month(myDate)/3, 0)) & "-" & Text(Year(myDate))

[AssassinUK]

Great Vid. Can you filter, lookup, search, etc on a calculated field?

[JulyTiger]

Do you know if a calculated field will calculate for existing records?

[JEffigy]

Yeah pity the example was so simply...how about looking up a value from a related table? Something possible in multiple other CRM systems...Sorry it bugs me when people go to all the trouble of creating a useful video then do a scenario that any monkey could work out, sorry just a little annoying.