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
      Icon for Super User rankSuper 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