Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter date in Calculate function

Hello,   I am posting because I am pretty new on Power BI and I seem to be stuck on a particular issue I hope you could help me with.   The problem is the following :   I have a list of number,...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Could you please tell me what is your desired output？
I have created a simple sample.

And the formula works well.

mesure december = 
var MAXI = month(LASTDATE(Data[Date]))
return

CALCULATE(sum(Data[Value]) , month(Data[Date]) = MAXI)

If it is possible, please provide your pbix file without privacy information and desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

     

    Sorry for the late reply.

     

    I will attache the related document do you know how to proceed ?

     

    The issue I have with my calculation is the following :

     

    The total on column 2 focus on last month and is ok (310). But i don't understand why the others month that should be filter appear in the list (january to november)