Forum Discussion

cashmaker777's avatar
cashmaker777
Frequent Visitor
8 years ago
Solved

Count: Cumulative by Month +Office.In.Charge

Hello, I´m new to PowerBI. I would like to count the  Cumulative of the table by:

 

  1. Month
  2. Office.In.Charge

 

Which operation / filter can I use?

 

 

Cumulative by month =
CALCULATE (
SUM ( 'Table'[Number] ),
FILTER ('Table,
'Table'[MonthsDIFF] <= EARLIER ( 'Table'[MonthsDIFF] )
)
)

 

 

TARGET:

Cumulative by month + office in charge = 

Need Help
Tips and Tricks
  • cashmaker777's avatar
    cashmaker777
    8 years ago

    This worked!

     

     

    Comulative.Office =
    CALCULATE (
    SUM ( 'Table'[Number] ),
    ALLEXCEPT ( 'Table', 'ATable'[Office.in.Charge] ),
    'Table'[MonthsDIFF] <= EARLIER ( 'Table'[MonthsDIFF] )
    )

1 Reply

  • cashmaker777's avatar
    cashmaker777
    Frequent Visitor
    8 years ago

    This worked!

     

     

    Comulative.Office =
    CALCULATE (
    SUM ( 'Table'[Number] ),
    ALLEXCEPT ( 'Table', 'ATable'[Office.in.Charge] ),
    'Table'[MonthsDIFF] <= EARLIER ( 'Table'[MonthsDIFF] )
    )