topic calculate the stock total between the current line date and first purchase date in DAX Commands and Tips

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

Hamdi-FAKHFAKH — Fri, 16 Sep 2022 15:24:35 GMT

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

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

tamerj1 — Fri, 16 Sep 2022 17:02:33 GMT

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

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

Hamdi-FAKHFAKH — Fri, 16 Sep 2022 17:06:44 GMT

tamerj1 I already try the same problem

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

tamerj1 — Fri, 16 Sep 2022 17:15:34 GMT

Hamdi-FAKHFAKH
Use

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

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

Hamdi-FAKHFAKH — Fri, 16 Sep 2022 18:44:17 GMT

the same problem 😔

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

tamerj1 — Fri, 16 Sep 2022 18:55:55 GMT

Hamdi-FAKHFAKH
Sorry for that. Please try

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

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

Anonymous — Thu, 29 Sep 2022 00:41:52 GMT

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