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

今天就学习课程吧！

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

Working in tables

Working in tables

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

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

Working in tables

“

- [Instructor] Management would like us to report program information for each project. Like any report, we'll need to have all that information necessary to do so. Our program table is currently missing in the list of tables. So to do that, we'll go to Transform Data and expand on some existing queries, and create a new one as well. So in our project staging query, we go to MSDYN Projects. We want to duplicate that, so we'll right click on it and select Duplicate. We'll call this Programs. So we'll rename it to Programs Staging. And we'll change this table. So we'll go to the source here, and under the entities where it says Data and Folders, click on Folder and press Continue. And we'll scroll down and find our MSDYN Programs table. And here it is. And we'll expand that table. So now we have a list of all the fields for the raw data in our staging set. We need to also duplicate that. So we'll right click on it…

内容