Trailing 12 Months of Sum Per Month

[israabuhasna]

Hi,

I know there are many threads ont his topic however I hit a bump when I apply it to my data. My goal is to create a visual in which 12 months prior to todays month is the axis to the visual and the SUM of my sales is the column. Like any normal visual. However, when I apply this measure, the axis shows every day of every month of the past 12 months. When I drill to have the axis show only 'Months' and not 'Days' it shows only from January to December. Not from Sept 2018 to Sept 2019 which is my goal. 

Measure:

TTM_AwardedOpps = 
Var CurrentDate = TODAY()
Var PreviousDate = DATE(YEAR(CurrentDate),MONTH(CurrentDate)-12,DAY(CurrentDate))
Var RESULT = CALCULATE(SUM(Table[Sales]),FILTER('Table','Table'[DateAwardedLost]>=PreviousDate && 'vw_Awarded _Term_Opportunity'[DateAwardedLost]<=(CurrentDate)))
Return RESULT

My Goal visual:

[v-xicai]

Hi @israabuhasna  ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @israabuhasna ,

You may put date field into chart visual, remain the hierarchy Year and Month, then click button “Expand all down one level in the hierarchy” in the upper right of visualization.

After expanding the hierarchy:

Best Regards,

Amy

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