Forum Discussion

Tito's avatar
Tito
Helper IV
2 years ago
Solved

MAX-Formula

Hello, I have a problem with the MAX formula. In my example, I want to calculate a sum of sales with maximum of date only for group A. And for group B I calculate the sum of sales without the maximu...
Need Help
  • Tito's avatar
    Tito
    2 years ago

    Hello,

    I have solved the problem with the following DAX function.

    Thank you very much for your support. 

Tito's avatar
Tito
Helper IV
2 years ago

Thank you for your answer.
I have tried the formula, but the calculation is not correct.

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, Tito 

 

try below code 

sum sales current 2 = 
var a =  CALCULATE(
            MAX(tebelle1[sales]),
            ALLEXCEPT(tebelle1,tebelle1[date]),
            KEEPFILTERS(tebelle1[group]="a")
                   )

var b = CALCULATE(
            sum(tebelle1[sales]),
            tebelle1[sales]=a
                  )

var c = CALCULATE(
            sum(tebelle1[sales]),
             KEEPFILTERS(tebelle1[group]="b")
                  )

return 
  b+c