SOLVED

Cost and Schedule Health in PWA (and for PowerBI Template)

%3CLINGO-SUB%20id%3D%22lingo-sub-1321676%22%20slang%3D%22en-US%22%3ECost%20and%20Schedule%20Health%20in%20PWA%20(and%20for%20PowerBI%20Template)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1321676%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20recently%20added%20the%20PowerBI%20app%20for%20PWA%20and%20was%20wondering%20how%20is%20Cost%20and%20Schedule%20Health%20calculated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20no%20fields%20of%20that%20name%20in%20my%20PWA%20custom%20fiels%20list.%20All%20the%20indicators%20are%20%22Green%22%20but%20I%20know%20for%20a%20fact%20some%20costs%20and%20schedule%20issues%20exist.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1323903%22%20slang%3D%22en-US%22%3ERe%3A%20Cost%20and%20Schedule%20Health%20in%20PWA%20(and%20for%20PowerBI%20Template)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1323903%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F624295%22%20target%3D%22_blank%22%3E%40khyron%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EThey%20are%20calculated%20in%20the%20Power%20BI%20file%20using%20a%20DAX%20expression%20which%20uses%20data%20from%20default%20fields%20in%20Project%20Online%2C%20see%20this%20post%20for%20details%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fproject-support-blog%2Fa-new-project-online-content-pack-for-power-bi%2Fbc-p%2F708475%2Fhighlight%2Ftrue%23M276%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fproject-support-blog%2Fa-new-project-online-content-pack-for-power-bi%2Fbc-p%2F708475%2Fhighlight%2Ftrue%23M276%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EPaul%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi there

 

I have recently added the PowerBI app for PWA and was wondering how is Cost and Schedule Health calculated?

 

There are no fields of that name in my PWA custom fiels list. All the indicators are "Green" but I know for a fact some costs and schedule issues exist.

2 Replies
Highlighted
Solution

Hello @khyron,

They are calculated in the Power BI file using a DAX expression which uses data from default fields in Project Online, see this post for details:

https://techcommunity.microsoft.com/t5/project-support-blog/a-new-project-online-content-pack-for-po...

Paul 

Highlighted

Paul I'd shake your hand if I could.