How to break down by month a measure using DATESINPERIOD?

[Anonymous]

I have my measure that works fine:

Hours LTM:=

CALCULATE(

[Registered Hours] ,

'Billable Type'[Billable Type]="Chargeable"

,DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH)

)

I use it on several visuals; to show the ‘last 12 months hours’ breaking them down by different dimensions…

It works!

Now I am trying to break them down by month:

But the results don't make sense…

I just realize it is just showing the last 12 months for January, and the last 12 months for December, and so on… whereas what I want is the last 12 months per month… that is, to put the total 1390,60 in the corresponding months…

How can I do it?

(I tried using just     [Registered Hours] ,'Billable Type'[Billable Type]="Chargeable"     but I get data aaall the way back to many years ago…)

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

Hours LTM:= CALCULATE([Registered Hours],'Billable Type'[Billable Type]="Chargeable",previousyear('Date'[Date])

If not, then share the download link of the PBI file.