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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        KH11NDR，

        Do you create table visual as mine? Could you please share PBIX file to me? You can share PBIX file through OneDrive.

        Regards,
        Lydia