Trailing 12-Months in Visual

[anelliaf]

I'm using the following formula to calculate the total for last month:

Last MTD Costs = CALCULATE(SUM('Usage Details - 2'[Cost]),PREVIOUSMONTH(dateDimension[Date]))

 

I'm using an identical formual for last YTD total, which works.  I also have no interactions with other filters set.

 

Any ideas?

 

Thanks,

Frank

[Greg_Deckler · Accepted solution]

Well that formula should just you the previous month's costs. Need some definition around "doesn't work". Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[anelliaf]

Sorry, I'm not sure why that was posted.  I created a new thread and it posted and old draft.  I'll close this and post my new question.  thx!