Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
9 months ago
Solved

Date With Progress

Hi can anyone help me on my calculated column and measure. What i required is the sum of each trade base on the column date Desired output measure     Trade Progress col...
Need Help
  • wardy912's avatar
    wardy912
    9 months ago

    Hi AllanBerces 

     

     Add a calculated column as follows:

     

    TotalProgressByDate = 
IF(
    NOT(ISBLANK('Trade'[column date])),
    CALCULATE(
        SUM('Trade'[Progress]),
        FILTER(
            'Trade',
            'Trade'[column date] = EARLIER('Trade'[column date]) &&
            'Trade'[Trade] = EARLIER('Trade'[Trade])
        )
    )
)

     

    This will give you the following result:

     

     

    --------------------------------

    I hope this helps, please give kudos and mark as solved if it does!

     

    Connect with me on LinkedIn.

    Subscribe to my YouTube channel for Fabric/Power Platform related content!

wardy912's avatar
wardy912
Super User
9 months ago

Hi AllanBerces 

 

 Add a calculated column as follows:

 

TotalProgressByDate = 
IF(
    NOT(ISBLANK('Trade'[column date])),
    CALCULATE(
        SUM('Trade'[Progress]),
        FILTER(
            'Trade',
            'Trade'[column date] = EARLIER('Trade'[column date]) &&
            'Trade'[Trade] = EARLIER('Trade'[Trade])
        )
    )
)

 

This will give you the following result:

 

 

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

 

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!