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'm trying to get the sum of my inventory based on the maximum week # from my slicer.
For example, in the below image:
The Measure I'm trying to make can be seen in the tool bar below as well.
The metric should report the inventory for only the 37th week, but I'm having a challenge with this one.
Thank you for any help.
Solved! Go to Solution.
Inventory=
VAR maxweek = MAX( Calendar[week] )
RETURN
CALCULATE(
SUM( Sales[Amount] ),
Calendar[week] = maxweek
)
Inventory=
VAR maxweek = MAX( Calendar[week] )
RETURN
CALCULATE(
SUM( Sales[Amount] ),
Calendar[week] = maxweek
)
Amazing, thank you!
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 |