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

 
Parameter define how much days i want back

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    Adamkowalsky92 Try using

     

    dax
    VAR maxday = MAX(Sales[Day])
    VAR beforeday = CALCULATE(MAX(Sales[Day]), Sales[Day] < maxday)
    VAR sales = CALCULATE(SUM(Sales[Value]), Calendar[Date] = maxday)
    VAR salesbefore = CALCULATE(SUM(Sales[Value]), Calendar[Date] = beforeday)
    RETURN
    SUMX(
    VALUES(Sales[Day]),
    sales - salesbefore
    )

    • 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!