need to calculate plan % indivually from the available column "Planned **bleep**"

[BilalMakki00]

i need to calculate plan % indivually from the available column "Planned **bleep**". and every project start should same value as in "planned **bleep**" and for next result it should be (next date-prev). need to modify this dax in the availble powerbi file attched in the link.
https://jasarapmc-my.sharepoint.com/:u:/p/bilal_makki/EXIqj6hm7s1JtEnOQtA-5c8Bdi-VIa7VQIGHKsxFrLS9Tw... 

biweekly %.pbix

[v-fenling-msft · Accepted solution]

Hi, @BilalMakki00 

I am glad to help you.

Try the following DAX:

Plan % Indivually2 = 
VAR _ProjectNo = Major_SCurve[Project NO]
VAR _filterforcurproject = FILTER(Major_SCurve, Major_SCurve[Project NO] = _ProjectNo)
VAR _firstdateofproject = MINX(_filterforcurproject, Major_SCurve[Date])
VAR _previousdate = 
    CALCULATE(
        MAX(Major_SCurve[Date]),
        FILTER(
            _filterforcurproject,
            Major_SCurve[Date] < EARLIER(Major_SCurve[Date])
        )
    )
VAR _previouspercentage = 
    CALCULATE(
        MAX(Major_SCurve[Planned Cum.]),
        FILTER(
            _filterforcurproject,
            Major_SCurve[Date] = _previousdate
        )
    )
RETURN 
    IF(
        Major_SCurve[Date] = _firstdateofproject,
        Major_SCurve[Planned Cum.],
        Major_SCurve[Planned Cum.] - _previouspercentage
    )

I hope you find the above DAX helpful. If for solving your issue, please share more details and we will try our best to solve your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BilalMakki00]

Hi @v-fenling-msft  thank u very much, it working fine for plan % indiviually  , but same formula when i replace with actual % indiually , in the last cell it's reflecting the same % which is not accurate, can modify this for avctual %?
like in the below picture , actual update is till 26 dec 2024, but in 9 jan 2025 it's showing same actual cummlaive value?