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.
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.
dude i came right , i had to use the measure instead of column to claculate what was needed...i went through a dax 101 tutorial and figured it out .
Hi,
Give the sample output what u want exactly
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
sorry dude still i didn't get u .
Give me sample data and outp put in image , that will give more clear for me .
sorry again
dude i came right , i had to use the measure instead of column to claculate what was needed...i went through a dax 101 tutorial and figured it out .
Hi @modadda,
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?
Regards
cool !!!
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.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |