Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

cumulative data base on earlier dates with client filter based on slicer

Hello,   First sorry for my English which is not my mother tongue.   I have a huge table containing 3 columns : Client reference code, monthly costs and monthly date (first day of the month). Th...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    create a column like

    Cumulative Sum = 
CALCULATE(
SUM(Table[monthly costs]),
FILTER(ALL(Table), Table[monthly date] <= EARLIER(Table[monthly date]) && Table[Client reference code] = EARLIER(Table[Client reference code]) )
)

    and use it as chart Y-axis value

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

create a column like

Cumulative Sum = 
CALCULATE(
SUM(Table[monthly costs]),
FILTER(ALL(Table), Table[monthly date] <= EARLIER(Table[monthly date]) && Table[Client reference code] = EARLIER(Table[Client reference code]) )
)

and use it as chart Y-axis value

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks a lot!!!