Forum Discussion

Robin96's avatar
Robin96
Icon for Helper II rankHelper II
2 years ago

Running total problem

i have a switch case that is showing different values for each row in a matrix i have a table that shows the income, expenses and my cashflow per week. This is how the matrix should show values...
Need Help
Robin96's avatar
Robin96
Icon for Helper II rankHelper II
2 years ago

Greg_Deckler 

This is the data i have as test


This is the expected output i want:
The orange fields is what i use for the the calculation, and the green field is where i want the result

 

JamesFR06's avatar
JamesFR06
Icon for Resolver IV rankResolver IV
2 years ago

Hi

 

Please try this

Cashflow =
VAR minweek =
MIN ( RT[Week] )
VAR Firstcash =
CALCULATE ( MAX ( RT[Cash Balance] ), RT[Week] = minweek, ALL ( rt ) )
VAR Activweek = RT[Week]
VAR RTotal =
CALCULATE (
SUM ( RT[Net Cashflow] ),
RT[Week] > minweek
&& RT[Week] <= Activweek,
ALL ( RT )
)
VAR result =
IF ( Activweek = minweek, Firstcash, RTotal + Firstcash )
RETURN
result

 

 

  • Robin96's avatar
    Robin96
    Icon for Helper II rankHelper II
    2 years ago

    Hey,

    Thanks for the response! This did not generate the desired outcome. i dont have every column in the same table as you have here. 

    i also get an error on the syntax at "Activweek" not sure why, guess it needs an expression.

     

    • JamesFR06's avatar
      JamesFR06
      Icon for Resolver IV rankResolver IV
      2 years ago

      Sorry I do not realize that you got informations in different tables

       

      For Activweek, as you put it on a matrix use the selectedvalue(Date[Week])