hi i am very new to using power bi, i need help with , sales data which returns on every line how much stock i got on hand, i therefore add it into the visuals filter as an average so it shows exactly how much i have .
i want to use the vlaues as i see in the visual that have the averages aplied , to be able to calculate my stock levels by subtracting what i have on stock from another column of what my levels are
so i need the average of qty on hand for every item as that is my stock on hand
Solved! Go to Solution.
for an example if i sell product 'A' to 3 different customers it will show the current qty on hand on every tranactions(Line) .
if it shows i got 5 on hand , that 5 will appear 3 times and will show the sum of 15, i then changed it from sum to average in the visual filter , it then shows 3 on hand, as supposed to be.
i then have a minimum level for this item set to 50
i need to subtract the qty on hand from my min level, to be able to see if i am stocking enough of the item
i require to create a formula that takes the average of the qty on hand( which is my current stock holding) for the specific items
Great to hear the problem got resolved!Could you accept your reply as solution to help others who has similar issue easily find the answer and close this thread?