price
1 Topic
Raw Material Price
Hi guys, I have a measure (amount) whose define my amount of raw material and a table with this columns -raw material -price -amount -date of purchase What I need is another measure to define my price. For example, if my measure amount is 5000 for material 1 and my table is like: raw material price amount date of purchase material1 2,9 2000 18/dec/2023 material1 1,8 3500 20/dec/2023 material2 3,4 1000 12/dec/2023 material2 0,8 1500 10/oct/2023 I need to order my table by date of purchase descendent and calculate something like this: 3500*1,8 + (1500)*2,9 = 10650 Important, my amount is 5000, so I cant to surpass this amount, that's why I used 1500 instead of 2000 to multiply by 2,9. How can I do this measure?Solved1.2KViews2likes2Comments