Previous Month as filter not as running value

[bilingual]

Hi, i have made the formula 

Last Month = CALCULATE(SUM(Data_akk[Antal rejser]);PREVIOUSMONTH(Kalender[Dato]))

It works fine as a variable, but what i need is PREVIOUSMONTH as a filter, so my graph every month only shows the values of last month, can anybody help? 🙂

i have made Calender table in M , should i add there?

Kindr regards Daniel

[inna_sysco · Accepted solution]

Hi @bilingual !

I am assuming that you can create a calculated column in your Calendar table and determine the "previous month" with a similar formula:

Prev_month = IF (

AND (

'Calendar'[Date]

>= DATE ( YEAR ( NOW () ), MONTH ( NOW () ) - 1, 1 ),

'Calendar'[Date]

<= DATE ( YEAR ( NOW () ), MONTH ( NOW () ), 1 ) - 1

),

"*Previous month",

'Calendar'[MonthName]&" "&'Calendar'[Year]

)

Then it will not be a problem to use this column as a visual and page-level filter. 

Best wishes, Inna

[bilingual]

Hi Inna, it works almost, however, it only adds last month for the first date of the month, example 1 of february

[inna_sysco]

@bilingual , hmm, it's a bit strange...
I use the same formula and result on the screenshot below:

Could you, please, share some screenshots from your report?

[bilingual]

Thanks a lot Inna, it was my mistake in the formula !

[inna_sysco]

@bilingual , you're welcome!😉

Inna