welcome to XRM blog

In this article, we will explore how Power Fx simplifies Dataverse customization using a practical example: calculating a person’s age from their Date of Birth (DOB). 

What is Power Fx?

Power Fx is a declarative, low-code formula language designed for use across Power Apps, Power Automate, and Dataverse. It allows users to build dynamic calculations, automate processes, and enhance data management without traditional coding. 

Key Benefits of Power Fx in Dataverse? 

✅ No-code/low-code approach – Reduces dependency on developers.  

✅ Real-time calculations – Ensures instant updates when data changes. 

✅ Easy-to-learn – Based on Excel-like formulas.  

✅ Seamless integration – Works across Microsoft’s Power Platform ecosystem. 

Example: Calculating Age Using Power Fx in Dataverse 

Step 1: Create a Date of Birth field. 

 

1. Go to Power Apps -> Tables -> Select your Preferred table (e.g., Contact). 

2. Click Columns -> New Column 

3. Set the following details 

1. Display Name: Birthdate 
2. Behavior: Simple 
3. Data Type: Date Only 
4. Click Save & Close

Step 2: For the Age Field 

 

1. Click New Column 

2. Set the following details 

1. Display name: Age 

2. Data Type: Formula 

3. Formula: 
   (Note: Birthdate represents the field name for the birth date field.)     

  If(IsBlank(Birthdate), Blank(),If( 

     (Month(UTCToday()) > Month(Birthdate)) || 

  (Month(UTCToday()) = Month(Birthdate) && Day(UTCToday()) >=  Day(Birthdate)), 

     Year(UTCToday()) - Year(Birthdate), 

     Year(UTCToday()) - Year(Birthdate) - 1 

     ) 

  ) 
 

4. Now, Click on the Advanced options, present at the end 

1. Set Formula Data Type as Whole number. 
    

5. Click Save & Close. 

Step 3: Testing the Age Calculation  

1. Open your form. 

2. Create a new record and enter the Date of Birth. 

3. Click Save. 

4. Check the updated value in the Age field. 

 

Conclusion: 

With Power Fx, customizing Dataverse has never been easier. By using simple formulas organizations can implement real-time business logic, such as calculating Age from Date of Birth, without writing complex code. This approach makes applications more dynamic, user-friendly, and maintainable.