cancel
Showing results for
Did you mean:  Helper I

## How to sum all up to selected max date

Hallo

Can someone help me to create af measure that sum all post from first date to the max selected date in slicer.

This measure works (ofcauce)

Saldo = CALCULATE(SUM(NavPosteringer[Beløb]),
ALL(Datetable[Date]),
NavPosteringer[Bogføringsdato] <= DATE(2021, 08, 31))

but when i change to:
Saldo = CALCULATE(SUM(NavPosteringer[Beløb]),
ALL(Datetable[Date]),
NavPosteringer[Bogføringsdato] <= MAX(Datetable[Date]))

is dosent work.
How can i do it??

Best regards Andreas
1 ACCEPTED SOLUTION  Resident Rockstar

Did you select any date on the slicer?

Try this:

Saldo2 = CALCULATE(SUM(NavPosteringer[Beløb]), FILTER(ALL(NavPosteringer[Bogføringsdato]),NavPosteringer[Bogføringsdato] <= SELECTEDVALUE(Datetable[Date],MAX(Datetable[Date]))))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

6 REPLIES 6  Resident Rockstar

You need to use the  SELECTEDVALUE dax code.

Try this:

Saldo = CALCULATE(SUM(NavPosteringer[Beløb]),
ALL(Datetable[Date]),
NavPosteringer[Bogføringsdato] <= SELECTEDVALUE(Datetable[Date]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.  Helper I

Hallo

Thank you, but i get a error: Hmm?? have you any idea??  Resident Rockstar

That is because you need to use that in filter.

try this:

Saldo = CALCULATE(SUM(NavPosteringer[Beløb]),
Filter(ALL(Datetable[Date]),NavPosteringer[Bogføringsdato] <= SELECTEDVALUE(Datetable[Date])))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.  Helper I

Okay - now I not got a error, but is dont calculate.

Saldo2 = CALCULATE(SUM(NavPosteringer[Beløb]), FILTER(ALL(NavPosteringer[Bogføringsdato]),NavPosteringer[Bogføringsdato] <= SELECTEDVALUE(Datetable[Date])))

the saldo2 is blank.  Resident Rockstar

Did you select any date on the slicer?

Try this:

Saldo2 = CALCULATE(SUM(NavPosteringer[Beløb]), FILTER(ALL(NavPosteringer[Bogføringsdato]),NavPosteringer[Bogføringsdato] <= SELECTEDVALUE(Datetable[Date],MAX(Datetable[Date]))))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.  Helper I

Thank you som much - Is exacly what i want.  