Calculating periods

[bumoverflow]

Ciao friends

I have a (simple) problem with Power BI. When I want to write predefined period measure, the calculation returns value that I'm looking for but for all of the periods. 

Here is the break down of the result (how it should look like)

And this is the result

I wrote this using calcution groups, but even when I used measure intead the same error occured

As you can see I even hardcoded date to be 100% sure that the filter is working correctly.

[amitchandak · Accepted solution]

@bumoverflow , Please add a month year column in you calendar

Month Year = format([Date], "YYYY-MM")

A measure like this

calculate(selectedmeasure(), filter(calendar, calendar[Date] >=date(2023,04,01) ) )

calculate(selectedmeasure(), filter(calendar, calendar[Date] >eomonth(today(),-2) ) )

[bumoverflow]

Thanks a lot! It worked 😄