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,
There are some posts on using measures in calculated sum functions, but so far I've not been able to use these in solving my issue below. So I hope someone is able to help me out.
I've got a table showing storage levels by location, on given reported dates by product. My colleagues looking at the dashboard like to use area charts (see below), hence I have some measures, to be able to plot individual years and averages/min/max etc. For example like this: 2019 = CALCULATE(SUM('Storage By location'[storage Amount]), 'Date mapping Table'[Year]=2019)
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 |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |