Forum Discussion

BryceBicknell's avatar
BryceBicknell
Frequent Visitor
4 years ago
Solved

Min & Max Value within a date range

Hi all,   I am trying to work out a Min and a Max however what I would like to do is use these measures for an axis in a line chart.   As an example I have a =SUM(SALES) and what I would like to ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi BryceBicknell ,

     

    Please try:

    MIN_A = MINX(DATESINPERIOD('Calendar'[Date],MAX('Calendar'[Date]),-365,DAY),[A])
    MAX_A = MAXX(DATESINPERIOD('Calendar'[Date],MAX('Calendar'[Date]),-365,DAY),[A])

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

BryceBicknell ,

Do you have date column or date table in your data model?

Thanks,

Arul

BryceBicknell's avatar
BryceBicknell
Frequent Visitor
4 years ago

Yes I do I have both