Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Row based running total

Hi, I have a table /matrix where i can show running total measure in a column but i would like to show it as row based in a martix. As a example: Month  A B Jan  3 5 Total  ?( running...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , if you running across A and B value

 

sumx(filter(allselected(Table), Table[Month Year] = max(Table[Month Year])  && Table[Column] <= max(Table[Column]) ), Table[Value])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI Amitchandak,

Thanks. Here runing total is not across two column, its based on per column. please just consider only one column (Profit)

Month Profit
Jan 4
Total ? (runing total til Jan)
Feb 7
Total  ?( running total till February)
  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , If you use only a month, you will not get the total. Use two measures profit and Running total profit

    Cumm Sales = CALCULATE(SUM(Table[Profit]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

    Use date table, take month year from date table.

     

    Enable Show on Row in matrix