Forum Discussion
Running Total
Hi ALl, I have created the below DAX which calucaltes the running averages for "Bat Inns" which is everytime a batter has batted in my database, this is set as a column. Bat_RunningTotal_Bat...
amitchandak
Super User
Super UserChockers1 , Not very clear, But try a measure like
Bat_RunningTotal_Bat_Innings_Col =
SUMX(
FILTER(
ALL(Bat),
Bat[Player ID] = MAx(Bat[Player ID]) && Bat[Start Date] <= MAx(Bat[Start Date])
),
IF(ISBLANK(Bat[Bat Inns]), 0, 1)
)