Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
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.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
18 | |
15 | |
12 | |
11 | |
8 |
User | Count |
---|---|
24 | |
19 | |
12 | |
11 | |
10 |