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!

AllanBerces's avatar
AllanBerces
Post Prodigy
9 months ago

HI Shahid12523 thank you for the reply but dont show the rigth answer, for calculated show only true and false and for measure same number for all the trade.

Rufyda's avatar
Rufyda
Super User
9 months ago

Use this calculated column (not a measure):
TotalProgressByDate =
CALCULATE(
SUM('Trade'[Progress]),
FILTER(
'Trade',
'Trade'[Trade] = EARLIER('Trade'[Trade]) &&
'Trade'[column date] = EARLIER('Trade'[column date])
)
)

This gives the sum of Progress for each Trade on the same Date — not just TRUE/FALSE, and not the same number for all trades.

 


If this response was helpful, please accept it as a solution and give kudos to support other community member.