cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
draner Frequent Visitor
Frequent Visitor

EVM (BCWP, BCWS & ACWP) on specific period - MS Project

Hi everybody,

 

Today I have a new ask Smiley Happy

 

I want to display evolution of EVM (BCWP, BCWS & ACWP) on specific period.

But I don't know how I can do it.

 

I found BCWP, BCWS and ACWP into Projects Table, and after some bad attempts, I never found the correct date to put in axis to "create" the period.

 

I know it's simple, I want to create chart like this :

EMV Exemple.png

But I obtain this f*****g chart (with wrong date/period) :

BAD EMV.PNG

 

Have you any idea / suggesting ?

 

Best regards Smiley Happy

 

 

6 REPLIES 6
Community Support Team
Community Support Team

Re: EVM (BCWP, BCWS & ACWP) on specific period - MS Project

Hi @draner,

 

Can you share some detail content of your issue?(e.g dax formula, sample data)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
draner Frequent Visitor
Frequent Visitor

Re: EVM (BCWP, BCWS & ACWP) on specific period - MS Project

Hi @v-shex-msft,

 

I use oData connection on Project Online in french version.

 

I use default columns of the data source.

 

In next picture, you can see selected datas :

 

dataSampleEVM.png

 

'PlanningsDeRéférenceProjet'[DateDébutRéférenceProjet] = 'baselineProject'[dateStartBaselineProject]

 

'Projets'[CRTEAffectation] = 'Projects'[ACWP] ActualCost

'Projets'[VPAffectation] = 'Projects'[BCWS] PlannedValue

'Projets'[VAAffectation] = 'Projects'[BCWP] EarnedValue

 

ACWP, BCWS and BCWP are correct but it's the last value.

I wanna get progress of ACWP, BCWS and BCWP at specific date in period.

 

I think I use wrong table to make it, but i don't know

 

Do you know how i can do it ?

 

Community Support Team
Community Support Team

Re: EVM (BCWP, BCWS & ACWP) on specific period - MS Project

Hi @draner,

 

I think you need to create relationship between these tables.(e.g. create a calendar table, add the relationships) If the value can't match the date axis, the value fields will show the static value at the line chart.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
draner Frequent Visitor
Frequent Visitor

Re: EVM (BCWP, BCWS & ACWP) on specific period - MS Project

How can I do it ?

I have no idea !

 

Thanks a lot !

Community Support Team
Community Support Team

Re: EVM (BCWP, BCWS & ACWP) on specific period - MS Project

Hi @draner,

 

You can take a look at below steps.

 

Date Table formula:

 

datetable = 
var temp=UNION(VALUES(Table1[Date]),VALUES(table2[Date]))
return
CALENDAR(MINX(temp,[Date]),MAXX(temp,[Date]))

 

Then create relationship from table1[date] and table2[date] to calendar table's date field.

After above steps you line visual will calculate the relative value based on relationships.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
agasthya Frequent Visitor
Frequent Visitor

Re: EVM (BCWP, BCWS & ACWP) on specific period - MS Project

Were you able to solve this issue?

 

If Yes, Could you please provide me the steps needed to get this done or if possible the code used? Else if you were not able to get this done what workaroung method did you employ?

 

I am facing a similar issue while creating a EVM chart Programmatcally in MS project server 2016.

 

Regards

Agasthya