Running total of a measure which use DATESINPERIOD and months from fact table

[prakash_gautam]

Hi All,

I am using a measure below to display the months from fact table as described here

Billings12Months =
CALCULATE (
SUM ( 'Datatable'[Allowable] ),
DATESINPERIOD ( DimDate[Date], MIN ( DimDate[Date] ), +12, MONTH )
)

My attempt to get the running total of above measure is failing:

BillingsRunningTotal =
CALCULATE (
[Billings12Months],
FILTER ( ALLSELECTED ( DimDate ), DimDate[Date] <= MAX ( DimDate[Date] ) )
)

BillingsRunningTotal2 =
SUMX (
FILTER (
ALLSELECTED ( DimDate[Date] ),
DimDate[Date] <= MAX ( ( DimDate[Date] ) )
&& YEAR ( DimDate[Date] ) = YEAR ( MIN ( DimDate[Date] ) )
),
[Billings12Months]
)

[BillingsRunningTotal] return same values as [Billings12Months] (please see screen 1 attached) and
[BillingsRunningTotal2] return wrong values and month start from Jan, 17 instead of May, 17 (please see screen-2)

Please help me to calculate the running total. If possible please describe how your solution is working so that I can be better in DAX.

Thanks

[parry2k]

@prakash_gautam what you are trying to achieve?

[prakash_gautam]

I am trying to calculate the running total of the existing measure [Billings12Months].