cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AhmedSalih
Most Valuable Professional
‎12-06-2022 05:40 AM

Work with Dataverse formula columns (preview)

CLICK HERE TO WATCH THE TUTORAIL VIEW 

DATAVERSE FORMULA COLUMNS 

Formula columns are columns that display a calculated value in a Microsoft Dataverse table. Formulas use Power Fx, a powerful but human-friendly programming language. Build a formula in a Dataverse formula column the same way you would build a formula in Microsoft Excel. As you type, Intellisense suggests functions and syntax and even helps you fix errors. 

 

FORMULA COLUMN TO CALCULATE THE PERCENTAGE CLICKS OF TOTAL SALES 

AhmedSalih_0-1670333038604.png

 

FORMULA COLUMN USING THE SWITCH & YEAR FUNCTION 

AhmedSalih_1-1670333083604.png

 

FORMULA COLUMN USING ADDDATE FUNCTION TO ADD 1 YEAR UNIT 

AhmedSalih_2-1670333122785.png

 

FORMULA COLUMN USING YEAR FUNCTION TO PRODUCE YES/NO BOOLEAN  

AhmedSalih_3-1670333153793.png

 

FORMULA COLUMN USING REPLACE FUNCTION 

AhmedSalih_4-1670333189494.png

 

FORMULA COLUMN USING ISOWeeNum FUNCTION 

AhmedSalih_5-1670333227762.png

 

FORMULA COLUMN USING AND FUNCTION 

AhmedSalih_6-1670333275515.png

 

FORMULA COLUMN USING MIN & MAX FUNCTIONS

AhmedSalih_10-1670333577414.png

 

FORMULA COLUMN USING SUM FUNCTION

AhmedSalih_13-1670333670194.png

 

 

FORMULA COLUMN USING MID FUNCTION

AhmedSalih_8-1670333383325.png

 

FORMULA COLUMN USING DATEDIFF & CONCATENATE FUNCTIONS

AhmedSalih_9-1670333417593.png