Getting outcome of a measure on on the next day line

[Anonymous]

Hi,

That's my first post here. Until now I have somehow managed to find solutions to my problems but in the case I'm working on now I can't see the light at the end of the tunnel so I would really appreciate any suggestions.

I have a measure B which is a running sum of the calculated column A. What I need to do is to move my measure outcome to the next day. The first row in the moved column needs to be ignored in the calculation.

Measure B = 

CALCULATE(SUM('Sales Amount'[Total Sales]);

                    FILTER(ALLSELECTED('Sales Amount');

'                               Sales Amount'[Date] <= MAX('Sales Amount'[Date])

))

I would be really thankful for any input you might have.

[parry2k · Accepted solution]

@Anonymous remove equal to sign from the measure and try.

I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

I've looked everywhere but here. That works great, thank you!