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

 

 

TradeProgresscolumn date
Mech6.6610/27/2025 0:00
Plumber1.61 
Strcut-0.4 
Mech0.1110/27/2025 0:00
Plumber0.1 
Strcut0.1 
Plumber-0.4 
Mech14.810/27/2025 0:00
Mech0.1210/27/2025 0:00
Strcut0.21 
Plumber9.64 
Strcut0.11 
Plumber0.1 
Plumber3.21 
Strcut4.12 
Civil1.3910/27/2025 0:00
Civil0.8910/27/2025 0:00
Civil0.6810/27/2025 0:00
Strcut-0.4 
Strcut0.1 
Plumber3.21 
Strcut0.1 
Plumber3.21 
Civil0.5710/27/2025 0:00
Elect8.6210/27/2025 0:00
Elect6.6610/27/2025 0:00
Elect6.6610/27/2025 0:00
Plumber0.1 
Strcut12.05 
Plumber0.42 
Strcut1.25 
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!

6 Replies

  • 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!

  • Shahid12523's avatar
    Shahid12523
    Community Champion
    9 months ago

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