problem with total progressive

[paglioz3]

Hi all,

I need to calculate a progressive value in base of the period filtered by user, from older to laster, but the result sum start from the last date. I use the script:

progressive_value=
VAR MinDate = MIN ( 'CALENDAR'[Date] ) -- Saves the last visible date
RETURN CALCULATE ([value], 'CALENDAR'[Date] >= MinDate )
 
And this is the actual result:

date	value	progressive_value
nov-19	3348	38393
dic-19	4678	35045
gen-20	3566	30367
feb-20	3020	26801
mar-20	1704	23781
apr-20	10652	22077
mag-20	1457	11425
giu-20	1556	9968
lug-20	3987	8412
ago-20	3697	4426
set-20	729	729

Any suggestion?

[vanessafvg]

you mean like this?

progressive_value =
VAR MinDate =
MIN ( ALLSELECTED ( 'CALENDAR'[Date] ) ) -- Saves the last visible date
RETURN
CALCULATE ( [value], 'CALENDAR'[Date] >= MinDate )

[paglioz3]

Thank's but no, with ALLSELECTED funtion returned an error (

the MIN function accepts only a column reference as an argument
)

for completeness, the measure [value] = calculate(sum([import]))

[v-kelly-msft · Accepted solution]

Hi  @paglioz3 ,

Try below expression:

progressive_value =
VAR MinDate =
MINX ( ALLSELECTED ( 'CALENDAR'),'CALENDAR'[Date] ) -- Saves the last visible date
RETURN
CALCULATE ( [value], 'CALENDAR'[Date] >= MinDate )

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[paglioz3]

Thanks!

Below the complete code:

progressive_value =

VAR MinDate = MINX ( ALLSELECTED ( 'CALENDAR'),'CALENDAR'[Date] ) -- Saves the last visible date

var MaxDate = MAX ('IND'[Date])

var Value= CALCULATE (IND[Amount])

RETURN

CALCULATE ( Value, 'CALENDAR'[Date] >= MinDate, 'CALENDAR'[Date] <= MaxDate )