Forum Discussion
Last twelve months
Hi, In the table below, I have presented some monthly cost data - each data represents the sum of the various costs items for each month. The input data is a spreadsheet with credit card transact...
Hi
If you have a date table it is easy.
12 month =
var datemax=selectedvalue(Date[Month])
return
calculate(sum(cost),removefilters(date[Month)),DATESINPERIOD('Date'[Date],datemax,-11,Month))