Date With Progress

[AllanBerces]

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	column date
Mech	6.66	10/27/2025 0:00
Plumber	1.61
Strcut	-0.4
Mech	0.11	10/27/2025 0:00
Plumber	0.1
Strcut	0.1
Plumber	-0.4
Mech	14.8	10/27/2025 0:00
Mech	0.12	10/27/2025 0:00
Strcut	0.21
Plumber	9.64
Strcut	0.11
Plumber	0.1
Plumber	3.21
Strcut	4.12
Civil	1.39	10/27/2025 0:00
Civil	0.89	10/27/2025 0:00
Civil	0.68	10/27/2025 0:00
Strcut	-0.4
Strcut	0.1
Plumber	3.21
Strcut	0.1
Plumber	3.21
Civil	0.57	10/27/2025 0:00
Elect	8.62	10/27/2025 0:00
Elect	6.66	10/27/2025 0:00
Elect	6.66	10/27/2025 0:00
Plumber	0.1
Strcut	12.05
Plumber	0.42
Strcut	1.25

[kushanNa · Accepted solution]

Hi @AllanBerces 

Please check if the attached pbix file calculated column and measure help you 

[wardy912 · Accepted solution]

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]

Hi @wardy912 @kushanNa thank you very much for the reply, work as i need.

[kushanNa · Accepted solution]

Hi @AllanBerces 

Please check if the attached pbix file calculated column and measure help you 

[Shahid12523]

Calculated Column to flag rows with a date:

HasDate = NOT(ISBLANK('YourTable'[column date]))

Measure to sum progress by trade for rows with a date:

Progress by Trade with Date = CALCULATE( SUM('YourTable'[Progress]), FILTER('YourTable', NOT(ISBLANK('YourTable'[column date]))) )

Use this in a matrix with Trade as rows and column date as a filter or slicer. 

[AllanBerces]

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]

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.