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

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

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

    Do you think it has anything to do with me Unpivoting my columns?

     

    Original Data

     

    Project ID01/07/201701/08/201701/09/201701/10/201701/11/201701/12/201701/01/201801/02/2018
    AAAA05101520253035
    BBBB07121824303642

     

    Power BI Table

     

    ProjectIDDatesValue
    AAAA01/07/20170
    AAAA01/08/20175
    AAAA01/09/201710
    AAAA01/10/201715
    AAAA01/11/201720
    BBBB01/07/20170
    BBBB01/08/20177
    BBBB01/09/201712
    BBBB01/10/201718
    BBBB01/11/201724

     

    And then in Power BI Matrix table, another row showing the cumualtive totals.

     

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

        Thank you, I'll use that as my suggestion, I know where I was going wrong now, I was using my Master Calendar Months for the column and not the date field from my table.

         

        Thanks again, I'm pretty sure I'll be needing more help, Im an X QlikView