Inventory valuation with last purchase price

[Anonymous]

Need help to valuate the closing balace inventory with the latest purchase price. I have the tables:

"Inventarios" containing historical data of inventories at the end of each month with the following fields: Fecha (date); art (Articule code); cant (stock quantities)

"ARTIMP" containing historical data of purchases with the followig fields : Fecha (pruchase date); art; cant (purchase quantities); costo_unitario (purchase price)

"ARTCOM" containing the master data of articles with the fields: art; name

"calendario" which is the date table 

I need a meassure or column to calculate the values of inventories at the end of each month valuated at the last purchase price of each item.

@Greg_Deckler 

@GilbertQ 

@nickyvv 

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

This might help but hard to tell: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814

[v-eachen-msft]

Hi @Anonymous ,

Could you please share your sample data and expected result to me if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.

[Anonymous]

Please find the link below with files I refer to. 

My Idea is to valuate the inventory of each product at month end at the latest available price (costo) in the file ARTIMP.

https://traxability-my.sharepoint.com/:f:/p/amenchaca/Ej5ndkse4FRFu0Xu4z2g2WUBtAkP7cKD-S5cK42b3IhKAw...

Thank you in advance for your help

[GilbertQ]

Hi there

Could you provide a sample data of what you are looking for?