Forum Discussion

Mmahachi's avatar
Mmahachi
Icon for Advocate I rankAdvocate I
6 years ago

max table filter not working

In my calendar table I have 2 columns other than my key date field one is to say 'yes' or 'no' depending on if the period has been closed by accounting and the second to show a user friendly display ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Mmahachi , I need some data to suggest. Try

 

Last Period Closed =
var _LastClosed = maxx(filter(allselected('Calendar'),'Calendar'[AccountPeriodClosed]="Yes"),[AccountPeriodClosed])

return
CALCULATE(MAX('Calendar'[Fiscal Period Display]), FILTER('Calendar','Calendar'[AccountPeriodClosed] =_LastClosed ))

 

or


Last Period Closed =
var _LastClosed = maxx(filter(allselected('Calendar'),'Calendar'[AccountPeriodClosed]="Yes"),[AccountPeriodClosed])

return
CALCULATE(MAX('Calendar'[Fiscal Period Display]), FILTER(allselected('Calendar'),'Calendar'[AccountPeriodClosed] =_LastClosed ))