Forum Discussion

bumoverflow's avatar
bumoverflow
Frequent Visitor
3 years ago
Solved

Calculating periods

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.

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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) ) )

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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) ) )