Forum Discussion

alucas85's avatar
alucas85
Regular Visitor
6 years ago
Solved

Indicate MAX value in time series

Good morning I have a lot of data like this: Date lot number manufactured (kg) 01/01/2020 1 200 01/01/2020 2 400 01/01/2020 3 300 01/01/2020 4 100 02/01/2020 5 100 ...
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    @alucas85

    you can also try to create two measures as below.

    MAX = MAXX('Table',CALCULATE(sum('Table'[manufactured (kg)]),ALLEXCEPT('Table','Table'[Date])))

MIN = MINX('Table',CALCULATE(sum('Table'[manufactured (kg)]),ALLEXCEPT('Table','Table'[Date])))

    1.PNG

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

@alucas85

you can also try to create two measures as below.

MAX = MAXX('Table',CALCULATE(sum('Table'[manufactured (kg)]),ALLEXCEPT('Table','Table'[Date])))

MIN = MINX('Table',CALCULATE(sum('Table'[manufactured (kg)]),ALLEXCEPT('Table','Table'[Date])))

1.PNG

alucas85's avatar
alucas85
Regular Visitor
6 years ago

Perfect. Thank you!