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

[draner]

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 :

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

Have you any idea / suggesting ?

Best regards 🙂

[v-shex-msft]

Hi @draner,

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

Regards,

Xiaoxin Sheng

[draner]

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 :

'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 ?

[v-shex-msft]

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

[draner]

How can I do it ?

I have no idea !

Thanks a lot !

[v-shex-msft]

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

[agasthya]

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