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!

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.