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 trying to calculate GMROI per item and am having trouble getting the average inventory cost.
My data is something like this:
Date | Store | Item | SOHValue |
30 May 2022 | A | 1 | 10 |
30 May 2022 | B | 1 | 20 |
6 June 2022 | A | 1 | 10 |
6 June 2022 | B | 1 | 20 |
13 June 2022 | A | 1 | 10 |
13 June 2022 | B | 1 | 20 |
If I try
Instead I want the 90 divided by the number of dates (3), so I'm getting an average SOH overall instead of per store.
Can anyone please help?
Thanks,
Michael
Solved! Go to Solution.
Create below measure and put it in card
Create below measure and put it in card
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |