Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago
Solved

How do i create a calculated column or measure for totalling up another column as cumulative?

Hi Guys,   This is what I want to do, create another column or measure that calculates Total sales per month per project.  My data is exactly how it is in the table without the "Total Sales" column...
Need Help
KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago

What's the Dax for this as a measure or column as I can't get the Quick measure calculation to do what I want.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

KH11NDR,

Create a measure using DAX below.

total sales = CALCULATE(SUM(Table[Sales]),FILTER(ALL(Table[Date]),Table[Date]<=MAX(Table[Date])))



Regards,
Lydia

  • KH11NDR's avatar
    KH11NDR
    Icon for Helper IV rankHelper IV
    8 years ago

    Sorry, That hasn't worked for me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      KH11NDR,

      What error message or what result do you get? Do you create a measure? Make sure you create a measure rather than a calculated column.

      Regards,
      Lydia

      • KH11NDR's avatar
        KH11NDR
        Icon for Helper IV rankHelper IV
        8 years ago

        Yes it's a measure, I don't get any error messages, just a blank row, column.