Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum a Column by the Value in Another Column

Hi, I'd like to sum the values in a column based on the value in another column. Here is an example of my data:   I'd like a new column which sums the Diff. Time for each Work Area. In this ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You might have create a new column in aseqdn (2)

    Work Area = related(ast[Work Area]) // refer other option in video https://www.youtube.com/watch?v=czNHt7UXIe8

     

    and create a new column like

     

    Column = CALCULATE(SUM('aseqdn (2)'[Diff. Time]),FILTER('aseqdn (2)',[Work Area]=EARLIER([Work Area])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , You might have create a new column in aseqdn (2)

Work Area = related(ast[Work Area]) // refer other option in video https://www.youtube.com/watch?v=czNHt7UXIe8

 

and create a new column like

 

Column = CALCULATE(SUM('aseqdn (2)'[Diff. Time]),FILTER('aseqdn (2)',[Work Area]=EARLIER([Work Area])))