Forum Discussion

lg01's avatar
lg01
Icon for Advocate III rankAdvocate III
1 year ago
Solved

Running total per category and date

I have the data below. I need to add a calculated column (or Measure) to get the running total of MaxPerMonth based on the year (Date) and the FacilityName. In other words, I need it to restart for e...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    lg01 

    you can try this

     
    Column = sumx(FILTER('Table','Table'[Date]<=EARLIER('Table'[Date])&&'Table'[FacilityName]=EARLIER('Table'[FacilityName])&&'Table'[MaxProduction]=EARLIER('Table'[MaxProduction])),'Table'[MaxPerMonth])
     
     
     

     

  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi lg01 

    Could you please confirm if your query have been resolved the solution provided by ryan_mayu ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

    Thank you

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
1 year ago

lg01 

you can try this

 
Column = sumx(FILTER('Table','Table'[Date]<=EARLIER('Table'[Date])&&'Table'[FacilityName]=EARLIER('Table'[FacilityName])&&'Table'[MaxProduction]=EARLIER('Table'[MaxProduction])),'Table'[MaxPerMonth])