From the course: Project Online Reporting with Power BI
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Working with conditional formatting
From the course: Project Online Reporting with Power BI
Working with conditional formatting
- [Instructor] Calculated columns are different than measures because they appear in the Query Editor, and you can view the results as an expression for each item in that table. We're going to build a new custom column for this assignment works calculation. We'd like to turn it into days instead of hours. To do that we'll go to Edit Queries on the Home ribbon. And we'd like to add it to the Assignments table. Here we'll add in our new column, so we'll go to Add Column. And we'll select Custom Column. We'll name our custom column AssignmentWorkinDays. And we'll add in the AssignmentsWork value and divide that by eight. So this is going to take the assignment worked that's in our current table set, and for each row in our table, it's going to divide that by eight hours per day, which happens to be a normal work day in our case. We'll press OK. And it adds the new column. Now as it added the column, it happens to be in…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.