Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return max date given criteria

Hello, I have a table of data that look like the below: Dates Area To display? 01-Jan-20 1 No 02-Jan-20 1 No 03-Jan-20 1 No 04-Jan-20 1 No 05-Jan-20 1 Yes 06-Jan-20...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    How about this?

    MAX_DATE =
CALCULATE (
    MAX ( YESTABLE[Dates] ),
    ALLEXCEPT ( GEOGRAPHY, GEOGRAPHY[AREA] ),
    YESTABLE[To display] = "Yes"
)

     

    If it doesn't work, please share us some sample data of your two tables, removing sensitive information.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.