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 help.

But when I add the date to the matrix, it doesn't show correctly.

 

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, Tito 

 

if you want only those name which have sales with max date and want to show only max date and name related to those date then change order of column in visual

 

like below  with same result measure.