Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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.
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.
Thank you in advance for your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.