Calculating running total based on month

Hi,

With a little bit of effort, this should be simple to solve.  Ensure you have a Calendar Table.  Create a relatioship from the Date column of your base table to the Date column of your Calendar Table.  In the Calendar Table, enter this formula in a column to extract the Month name

=FORMAT(Calendar[Date])

Now drag the Month from the Calendar Table to your visual.  Enter this formula to calculate running yield

=CALCULATE([Yield],DATESYTD(Calendar[Date],"31/12"))

Hope this helps.

Kolumam,

You want a running total (cummulative total).

Check the link below how to do it,

https://whatthetechisthat.wordpress.com/2017/05/30/power-bi-cumulative-totals/

If your date field in below table is a date heirarchy, then you can choose only month (and year if you need). You need to have a calendar table and establish relatship with your data table.

 Running Toal Measure =

      CALCULATE(

          Sum(Table[Yield],

          FILTER(All(Dim_Date[Date]), Dim_Date[Date] <= MAX(Dim_Date[Date]

          )

        )