Return Maximum date from field which is in current month

[MarkLuckett]

Hi,

I'm pulling out the maximum date from a data load and want to return the maximum date from data which is in current month. How do I amend this expression? Max([Posting Date]) - Posting date being the field

[Or]

Max(If(Monthname([Posting Date]) = Monthname(Today()),[Posting Date])) should work here, I believe. Note that if no values of Posting Date exist for the current month, this will return null.

[Bunim · Accepted solution]

Max({<Month={$(=month(today()))}>}[Posting Date]) 

[MarkLuckett]

Great, thanks for your help. This would perfectly.

[MarkLuckett]

Hi, unfortunately this returned the same values.