Forum Discussion

Adamkowalsky92's avatar
Adamkowalsky92
Frequent Visitor
1 year ago
Solved

Incorrect SUM

Hey, I need help with a simple formula. At first glance dax I wrote it is simple and in the lines it works correctly however the sum no longer match. The formula is supposed to search for the max da...
  • Adamkowalsky92's avatar
    Adamkowalsky92
    1 year ago

    I resolves problem myself ny using

    SUMX(
        SUMMERIZE(
                  Sales,Sales[Client],"Sum",CALCULATE(SUM(Sales[Value]),Sales[Date]=MAX(Sales[Date]))),Sum)

    _


    SUMX(
        SUMMERIZE(
                  Sales,Sales[Client],"Sum",CALCULATE(SUM(Sales[Value]),Sales[Date]=MAX(Sales[Date])-1)),Sum)

     

Adamkowalsky92's avatar
Adamkowalsky92
Frequent Visitor
1 year ago

Unfortunately, this is not a suitable solution:

1. you have not added a parameter option that defines the value by a certain number of days
2. I want the sum of only one day, not all earlier than max date

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Adamkowalsky92 ,
I tried to reproduce your visual object, but was unsuccessful. However, I think this problem can be solved quickly. To better help you solve the problem, could you provide some example pbix? Thank you very much for your cooperation!