Column that is the same value of max selected

[lcasey]

Hello,

Is there any way to have a column be the same exact data as the max in a calendar filter?

[Anonymous]

Create a Max Date Measure ... Try this...

[lcasey · Accepted solution]

Thanks a bunch,

I was able to resolve it with two measures:

maxDate = LASTDATE(ALLSELECTED('Calendar'[Date])) 

AGE = DateDiff(Max('00-Bad Debt - Invoices'[DOCDATE]),[maxDate],MONTH)