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,...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

For LM calculations I recommend using functions like PREVIOUSMONTH,  DATEADD or PARARALLELPERIOD. 

e.g. CALCULATE(sum(Data[Value]) , PREVIOUSMONTH('Calendar'[Date]))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/