Forum Discussion

Chockers1's avatar
Chockers1
Frequent Visitor
3 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Chockers1 ,

Assuming you have a column [match id] in your Bat table that uniquely identifies each match, please try:

Bat_RunningTotal_Bat_Innings_Col =
SUMX (
    FILTER (
        ALL ( Bat ),
        Bat[Player ID] = EARLIER ( Bat[Player ID] )
            && Bat[Start Date] <= EARLIER ( Bat[Start Date] )
            && (
                Bat[Start Date] < EARLIER ( Bat[Start Date] )
                    || Bat[match id] <= EARLIER ( Bat[match id] )
            )
    ),
    IF ( ISBLANK ( Bat[Bat Inns] ), 0, 1 )
)

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum