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 All,
I have an inventory table showing inventory status of products historically. Table looks like as below.
Product - Quantity - Inventory Date
Prod. A - 10 - 21.12.2020
Prod. B - 5 - 21.12.2020
Prod. A - 15 - 14.12.2020
Prod. B - 1 - 14.12.2020
Prod. A - 5 - 7.12.2020
Prod. B - 15 - 7.12.2020
The two measures I would like to get is, total max / min inventory value based on dates.
On this example total inv. value on each date is,
21.12.2020 - 15
14.12.2020 - 16
7.12.2020 - 20
So I expect the max measure to give me the result of 20 (which is 7.12.2020) and min measure to give me the result of 15 (which is 21.12.2020).
Looking forward to hear your suggestions & ideas.
Thanks,
Metin
Solved! Go to Solution.
@metin , Try a measure like
maxx(values(Table[Inventory Date]), calculate(Sum(Table[Quantity])))
@amitchandak Thanks a lot, it is working very well. And one more question, how can I show the date of max or min inventory (from example I would like to see 21.12.2020)?
@metin , Try a measure like
maxx(values(Table[Inventory Date]), calculate(Sum(Table[Quantity])))
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |