Forum Discussion

AlessandroBet's avatar
AlessandroBet
Icon for Helper V rankHelper V
5 years ago
Solved

Converting excel formula to DAX

Hi,

i need to convert a simple excel formula to DAX

The column B reads from column A + previous value

It is a accumulated sum

Cell B2= A2

Cell B3= A3+B2

Cell B4 =A4+B3

......etc

 

Need Help

7 Replies

  • AlessandroBet's avatar
    AlessandroBet
    Icon for Helper V rankHelper V
    5 years ago

    Yes i have the column "A" and i have to build the column "B" with DAX function

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Voilà

      here is the measure, 

      Total Turnover = CALCULATE(SUM(Sheet1[Turnover]), FILTER(
              ALLSELECTED(Sheet1),
              ISONORAFTER(Sheet1[Turnover], MAX(Sheet1[Turnover]), DESC)
      )
      )

       

  • AlessandroBet's avatar
    AlessandroBet
    Icon for Helper V rankHelper V
    5 years ago

    It doesn't work. I think there are some syntax errors inside your formula

    I have replaced the "sheet1" with my table

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      5 years ago

      "Syntax errors in my formula"! I have showed you the result.

      did you put the name of the column correctly?

      I think there is a space after Turnover

      Delete the space

       

       

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        5 years ago

        AlessandroBet 

        Did the formula solve your issue?

        If so please mark the topic as solved for the community.