Converting excel formula to DAX

[AlessandroBet]

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

[AlessandroBet · Accepted solution]

Many thanks. It works fine

[AlessandroBet]

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

I have replaced the "sheet1" with my table

[aj1973]

"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]

@AlessandroBet 

Did the formula solve your issue?

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

[AlessandroBet]

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

[aj1973]

Voilà

here is the measure, 

Total Turnover = CALCULATE(SUM(Sheet1[Turnover]), FILTER(

        ALLSELECTED(Sheet1),

        ISONORAFTER(Sheet1[Turnover], MAX(Sheet1[Turnover]), DESC)

)

)

[aj1973]

Hi @AlessandroBet 

Do you have a date column?