Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
BilalMakki00
Regular Visitor

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

 

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... 
BilalMakki00_0-1737533157605.png
biweekly %.pbix

1 ACCEPTED SOLUTION
v-fenling-msft
Community Support
Community Support

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
    )

 

vfenlingmsft_0-1737598119267.png

 

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.

View solution in original post

2 REPLIES 2
v-fenling-msft
Community Support
Community Support

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
    )

 

vfenlingmsft_0-1737598119267.png

 

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?

BilalMakki00_0-1738483403352.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.