How to get total of previous month (not previous Month-to-date)

[Niels_T]

On the left side I have a table with a MTD function. 

On the right side I have a table with just the standard value of Quantity (base).

I would like to have a measure that takes the total of previous month and have this value next to my MTD column. 

So basically having the 34 value from february from the right table next to the MTD measure in the left table.

The problem is I have a filter on my table with type: "Relative date" -> is in this day.

Is there a possibility to write a measure that gets the total of previous month linked to today of my date table?

-N

[amitchandak · Accepted solution]

@Niels_T , you van use previousmonth

previous month value = CALCULATE(sum('Table'[total hours value]),previousmonth('Date'[Date]))

This month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0) //today()
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date] >= _min && 'Date'[Date] <=_max ) )

Previous Month complete =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
var _day = datediff(_min, _max,day)+1
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date] >= _min && 'Date'[Date] <=_max))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA