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 ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Mmahachi ,

 

Try this measure.

 

Last Period Closed =
VAR LastClosed =
    CALCULATE (
        MAX ( 'Calendar'[Fiscal Period Display] ),
        FILTER (
            'Calendar',
            'Calendar'[AccountPeriodClosed]
        ) = "Yes"
    )
RETURN
    LastClosed

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

 

  • AntrikshSharma's avatar
    AntrikshSharma
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous  you might want to keep the "yes" inside parenthesis 😄