Moving average of a full month

[Anonymous]

Hi everyone,

At the moment i have a problem with my moving average. 

As you can see in the picture the moving average drops, because it count the month May. But the month May isn't over yet so it shouldn't be included in the moving average, because it gives a wrong image of the moving average. So i want to exclude the month we are in. I used the automatic formula that power bi provides;

Is there a way to exlude the current month in the moving average so it gives a right image of the moving average in three months?

[amitchandak · Accepted solution]

@Anonymous , in the last calculate, move all into a filter

and try like

filter(all(Kalendar]) , Kalendar[date]<=emonth(today(),-1)

[amitchandak · Accepted solution]

@Anonymous , in the last calculate, move all into a filter

and try like

filter(all(Kalendar]) , Kalendar[date]<=emonth(today(),-1)

[Anonymous]

Hi @amitchandak 

when i try to put in your exact part of the formula it gives a error ( is assume emonth =eomont because i cant find a dax with emont). First i copied your part:

FILTER(ALL(Kalender,Kalender[Datum]<=EOMONTH(TODAY(),-1)
but this give me a error that says ; The function Filter must have at least 2 arguments.

So i tried to fix this with this:

But then it gives a error at <=

and when i removed <= out of the formula:

FILTER(ALL(Kalender,Kalender[Datum]),EOMONTH(TODAY(),-1)

it says the following error: multiple table arguments are not allowed in the ALL/ ALLNOBLANK/REMOVEFILTERS function.

Any ideas how to solve this? thank you

[PaulOlding · Accepted solution]

You've missed out the closing bracket for ALL function:

FILTER(ALL(Kalender)