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
  • AlessandroBet's avatar
    AlessandroBet
    5 years ago

    Many thanks. It works fine

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.