Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Stock Valuation

I have two tables, one with the average prices and one with the stock movements. The price table is as follows ID Date __articulo __id __nuevopmc 28 27/01/2021 2626 2,5297 57 29/01...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Syndicate_Admin ,

     

    Please try:

     

    Measure = 
var _a = SUMMARIZE('tArticulos',tArticulos[Articulos],"StockAC",[Stock Ac],"UltimpoPrecio",[Ultimpo Precio])
return SUMX(_a,[StockAC]*[UltimpoPrecio])

     

    Final output:

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Syndicate_Admin ,

 

Please try:

 

Measure = 
var _a = SUMMARIZE('tArticulos',tArticulos[Articulos],"StockAC",[Stock Ac],"UltimpoPrecio",[Ultimpo Precio])
return SUMX(_a,[StockAC]*[UltimpoPrecio])

 

Final output:

Best Regards,

Jianbo Li

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

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Let me try it on the real model and I confirm that everything is fine. At the moment the solution looks very good.

Thank you very much for raising it.