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

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

Hi everybody,

 

Today I have a new ask 🙂

 

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 🙂

 

 

6 REPLIES 6
Community Support
Community Support

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
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
draner
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
Community Support

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
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
draner
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
Community Support

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
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
agasthya
New Member

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors