DAX date functions

[KimC2504]

Hi,
I have a list of data of which one column is the date the opportunity was last updated. Each opportunity can have several parts so I have created a formula to give me the last date the opportunity was updated as follows:

Last Updated = max(SFDC[Last Modified Date])

This formula is working fine however I now want to change the formula to look at opportunities that were updated over 2 months ago only. I have tried the following formula:

Updated > 2mths ago = [Last Updated]<(today()-60)
I have checked the formula and it is ok however it takes forever to read the data and the spinning wheel doesn’t stop and I end up pressing escape. Any suggestions as to how to solve this problem?

I would also like a criteria added of Version=”Current” if possible?

Thanks

Kim

 

[scottsen]

I would think the below would work fine, though... often this sort of thing works better if its related to a (smaller) calendar table, where you are filtering fewer rows there.

MaxOver2MoAgo := CALCULATE(MAX(SFDC[Last Modified Date]), SFDC[Last Modified Date] < TODAY() - 60)

Not clear to me if you were intending a calc column vs measure/calc field?