Power Community

Power Community

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

 

 

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Enable Early Access Wave 1 2023 | Power Platform

Like every 6 months, enabling Early Access is one of the best things to look forward to as Microsoft...

More Articles Like This

- Advertisement -spot_img