Forum Discussion

Lygral63's avatar
Lygral63
Icon for Helper I rankHelper I
2 years ago
Solved

DAX measure (Max/Min)

DAX measures for Max and Min   I am looking for the best way to calculate a measure that will compare sales from multiple year in a given Calendar Week and returning the max value. The measure shou...
  • Lygral63's avatar
    Lygral63
    2 years ago

    Yes, it's works. Thanks a lot. Much more simple than I expected. Thanks.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, Lygral63 

 

try below code 

 

min sales by week = MIN('calender week'[Total Sales])

 

max sales by week = max('calender week'[Total Sales])

 

 

  • Lygral63's avatar
    Lygral63
    Icon for Helper I rankHelper I
    2 years ago

    Thanks, but I don't think that works. I need a measure that looks at total sales by Year and by Calendar Week and then returns the max or min value. It could be that in Calendar Week 1 has the max value based on sales in 2016, but Calendar 2 has the max value based on sales in 2015. Hope it makes sense.