topic Re: need to calculate plan % indivually from the available column "Planned bleep" in DAX Commands and Tips

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

BilalMakki00 — Wed, 22 Jan 2025 08:11:34 GMT

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?e=OJ0ZGF

biweekly %.pbix

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

Anonymous — Thu, 23 Jan 2025 02:12:37 GMT

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.

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

BilalMakki00 — Sun, 02 Feb 2025 08:07:43 GMT

Hi Anonymous 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?

topic Re: need to calculate plan % indivually from the available column "Planned **bleep**" in DAX Commands and Tips

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

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

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

topic Re: need to calculate plan % indivually from the available column "Planned bleep" in DAX Commands and Tips

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

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

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