Split a fix value (Planned Cost) into 12months and show the accumulative by month

[Hindlaz]

Hello users,

I'm working on a report to show Planned cost vs Actual Cost by month with accumulative.

The planned cost is fixe for the full year 12months, for this reason it not linked to Calendar table. I'm limited and I cant create any new relationships in "Analysis Service" for geting DATA.

I used this meaure for Actual as it is changing every month(Transaction), but this measure is not working for Planned value(Even I created a new measure = divide Planned /12

Accumul EV = CALCULATE (

    ( 'Project Measures'[Earned Value with %]),

DATESBETWEEN('Calendar'[Date], DATE(YEAR(MIN('Calendar'[Date])),1,1), 'Calendar'[LastDate]))

Thank you in advance I appreciate your help

[Sahir_Maharaj]

Hello @Hindlaz,

Can you please try the following:

1. Distributing the Planned Cost

Monthly Planned Cost = 
DIVIDE(
    [Total Planned Cost], 
    12, 
    0
)

2. Cumulative Planned Cost

Cumulative Planned Cost = 
CALCULATE(
    [Monthly Planned Cost],
    FILTER(
        ALLSELECTED('Calendar'[Date]),
        'Calendar'[Date] <= MAX('Calendar'[Date])
    )
)

[Hindlaz]

Hello Sahir,
Thank you for your reply,

Unfortunatlly, the cumulative is noy working, tired other function but still have only the divided value