Problem with Period Calcs

[kg4u]

Hi,

I have read though many period solutions, and have tried several of the solutions presented on this forum, but I am still having a problem. I'm trying to create some period measures so that I can eventually create some change measures.  I am not getting any results for my Current Period and Prior Period calcutions.

My calculations are:

Current Period = CALCULATE(SUM(Report[Product 1]),

FILTER(ALL('Calendar Table'),'Calendar Table'[Date]=MAX('Calendar Table'[Date])))

Prior Period = CALCULATE(SUM('Report'[Product 1]),

FILTER(ALL('Calendar Table'),'Calendar Table'[Date]=MAX('Calendar Table'[Date])-1))

The above calculations are showing that the syntax is valid.  I do have a Calendar Table in my model which is linked to my data table.  The Calendar Table is linked on the Date column from the Calendar Table to the Entry_Dt_Full_Dt on my data table.  The Entry_Dt_Full_Dt is the lowest date level I have in the data table. 

What am I doing wrong?  Thanks for your guidance.

[v-zhangti · Accepted solution]

Hi, @kg4u 

You can try the following methods.

Current Period = CALCULATE(SUM(Report[Product 1]),
FILTER(ALL('Calendar Table'),[Month No]=SELECTEDVALUE('Calendar Table'[Month No])))

Prior Period = CALCULATE(SUM('Report'[Product 1]),
FILTER(ALL('Calendar Table'),[Month No]=SELECTEDVALUE('Calendar Table'[Month No])-1))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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