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

今天就学习课程吧！

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

Modifying a query

Modifying a query

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

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

Modifying a query

“

- [Instructor] Management would like to have us report on what each project type is and what business unit it belongs with. To do this, we'll need to enhance our current query in the template. I've opened up 01_05 querymods file and I'm on the step currently that says rename columns. I need to enhance this by adding in additional columns, so I'm going to go up to the step that says remove other columns and double-click on it. I'll scroll down and find the proj_businessunit_display field and I'll also scroll down a little farther and find proj_projecttype_display field and press OK. Now these two columns now are added into this particular query step, and if you scroll over to the right, you'll see the values in those columns. Now, currently, if I go to the last step in here, these fields will be null, so I don't want that to continue to happen, so I need to move this step because it's not getting basically merged…

内容