The below represented is the syntax for the divide function.Optionally, we can pass a value that represents an alternate result. Now we will see a few examples down based on the Divide function in Power BI. Here you can download the excel file used in this example. Assigned Projects, Completed Projects = Column names.Table1 = Excel table name where you are retrieving the data.Apply the below measure to calculate the sum of the assigned project and completed project as shown below:ĪssignedProjects = SUM(Table1) CompletedProjects = SUM(Table1).Click on the new measure from the ribbon to calculate the sum of the assigned project and completed project.First, we will calculate the SUM of the Assigned Project and Completed Project, before that make sure you have Loaded the data using the get data option.In this example, we will divide and calculate how many hours have taken Per Member of a Team to complete the project.In the below table, you can see that there are different Teams, and each Team has a different Team members count and Total hours to complete the project.Here, we will use the below sample table data to calculate the hours taken per member to complete the assigned project.Let us see how we can divide the two columns using the Power BI Divide function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |