Trailing 12-Months in Visual

Question

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 Answer

Well that formula should just you the previous month's costs. Need some definition around "doesn't work".&nbsp;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
&nbsp;
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-TITHW/m-p/434008

Forum Discussion

Trailing 12-Months in Visual

2 Replies

Related content

12 months trailing measure

Trailing 12 months DAX

Trailing 12 or Rolling 12 month sum

Trailing 12 months, year over year

Trailing 12-Month Visual