calculate the stock total between the current line date and first purchase date

[Hamdi-FAKHFAKH]

I try with calculated but it doesn't work, can I have some help

[Anonymous · Accepted solution]

Hi  @Hamdi-FAKHFAKH ,

Here are the steps you can follow：

1. Create calculated column.

Total stock = 
var _mindate=MINX(FILTER(ALL('Table'),'Table'[somme des achats]=EARLIER('Table'[somme des achats])), 'Table'[DATE])
var _currentdate='Table'[DATE]
return
SUMX( 
    FILTER(ALL('Table'),
    'Table'[DATE]>=_mindate&&'Table'[DATE]<=EARLIER('Table'[DATE])
    &&
    'Table'[somme des achats]=EARLIER('Table'[somme des achats])
    ),[somme des achats])

2. Result:

Best Regards,

Liu Yang

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

[Hamdi-FAKHFAKH]

@tamerj1 I already try the same problem

[tamerj1]

@Hamdi-FAKHFAKH 
Use 

=
CALCULATE (
    SUM ( 'Table'[Column] ),
    'Table'[Date] <= EARLIER ( 'Table'[Date] ),
    ALL ( 'Table' )
)

[Hamdi-FAKHFAKH]

the same problem 😔

[tamerj1]

@Hamdi-FAKHFAKH 
Sorry for that. Please try

=
VAR CurrentDate = 'Table'[Date]
VAR T1 =
    FILTER ( 'Table', 'Table'[Date] <= CurrentDate )
RETURN
    SUMX ( T1, 'Table'[Column] )

[tamerj1]

Hi @Hamdi-FAKHFAKH 
Try to replace BLANK ( ) with MIN ( [Date] )