课程: Microsoft Project for the Web: Reporting with Power BI

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Creating calculated columns

Creating calculated columns

课程: Microsoft Project for the Web: Reporting with Power BI

开始一个月试用 购买团队方案

Creating calculated columns

“

- [Instructor] Do you want to see the calculation as part of a query? If so, then using a calculated column is different from a measure, because they appear in the query editor and you can view the results of the expression for each item. To do that, we'll go to Transform Data. And we'll click on the projects table. Here we have a list of all of the fields, like we said earlier, including the project manager and the project names. We know there's eight projects. So we want to build a calculated column that tells us the status of these, based on a field called Progress, which is right here. And you can see that they have values in them. So we're going to go to, add column and, conditional column. We'll name the field, Project Progress. We'll check for the Progress field and we'll say, equals zero. And then it would be, not started. We'll add a second clause to that. So we'll check the Progress field again, and this…

内容