Running Sum on If statement in Power BI Table

Hi Anonymous 

First, create the month column in numeric form.

To calculate the running total for another measure then just add that measure code ( if block ) into your running total code.

example code :

Monthly Comm running sum = 
VAR month = MAX(Transactions[Fiscal Month])
VAR result =  CALCULATE(  
                         [MonthlyCommEarnedCalc],// OR Put if condtion measure code here
                         Transactions[Fiscal Month] <= month,
                         ALLSELECTED(Transactions)
                         )
 
Return result

 
check this tutorial :
https://www.youtube.com/watch?v=4gf3eueRD_g

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.