Rolling sum for month to month usage

kruizing — Sun, 01 Nov 2020 19:14:48 GMT

Hi!

I have a table in which the meter readings of my energy meters are stored every hour of the day. I have made a measure which calculates the consumption per month. Now I would like to have a rolling sum to calculate the annual consumption from month to month. For example, I want to make a line graph with in January 2020 the consumption of 01-2019 - 01/2020, in February the consumption of 02-2019 - 02-2020, March 2020 the consumption of 03-2019 - 03-2020.

My measurement for the monthly gas usage is as follows:

GasVerbruikMaandMutatie = CALCULATE([GasVerbruikPeriode], DATEADD(Kalender[Date],-0,MONTH))

GasVerbruikPeriode = CALCULATE(MAX(Energie[Gas])-(MIN(Energie[Gas])),Energie[Datum])

My table look like this:

I hope there is somebody who can help me out.

Thank you very much in advance!

Re: Rolling sum for month to month usage

MattAllington — Sun, 01 Nov 2020 19:22:04 GMT

Instead of DATEADD, try DATESINPERIOD. This function extends the dates back (or forward) the amount you choose.

topic Rolling sum for month to month usage in DAX Commands and Tips

Rolling sum for month to month usage

Re: Rolling sum for month to month usage