Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Max Date / Period for dates in a list/table

I do not understand why I am aaalways strugling with these things 😞

Could somebody teach me the correct way for these thing to always work??

MaxPeriod should everywhere be 10-2023.

Why is my measure nog working in this case?

Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    change this to the date columns from the sales table

    CALCULATE(
    MAX(SALES[Date]),

    REMOVEFILTERS())

4 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    pls try this

    CALCULATE(
    MAX(dimDate[Priod]),

    REMOVEFILTERS())
  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Thanks Ahmedx ,

    But not entirely what I need:

    It now find the latest date in the future.

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      3 years ago

      change this to the date columns from the sales table

      CALCULATE(
      MAX(SALES[Date]),

      REMOVEFILTERS())
      • rpinxt's avatar
        rpinxt
        Icon for Solution Sage rankSolution Sage
        3 years ago

        Yes this did the trick.

        Thanks.

        So I guess it will not work with the date from the autocalendar.