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.
I have a requirement I'm not sure how to implement.
We have a table of devices we need to upgrade to a new software version. however, each location will be able to upgrade a different number of devices in one week. I need to be able to run what-if scenarios where I increase/decrease the number of upgrades in a city but keep the others constant to get estimates on how long it will take to upgrade each location.
this is a simplification of my data:
location | device serial number |
NY | 123 |
LA | 124 |
NY | 134 |
LA | 345 |
HOU | 367 |
using the serial number to get a count of devices in each location
my thought is that I would create a parameter for each location and then use those parameters in a calculation,
Each parameter would have a value from 1 to 5 for example in 1 increments.
But I'm not sure how to properly filter the results for to get a table result like the following
Location | Devices | Devices/Week | Weeks |
NY | 100 | 5 | 20 |
LA | 210 | 4 | 53 |
HOU | 150 | 3 | 50 |
where via a slicer i can change the number of devices per week in NY alone.
in pseudo code I imagine this to look something like this:
if location = NY then divide Devices by "NY Devices/Week parameter"
elseif location = LA then divide Devices by "LA Devices/Week parameter"
else divide Devices by "HOU Devices/Week parameter"
but not sure how to translate that into DAX.
Solved! Go to Solution.
@briodan,
Please check if what-if parameter and DAX in the attached PBIX file returns your expected result. If not, please describe more details about the week parameter and how you get the second table based on the first table.
Regards,
Lydia
@briodan,
Please check if what-if parameter and DAX in the attached PBIX file returns your expected result. If not, please describe more details about the week parameter and how you get the second table based on the first table.
Regards,
Lydia
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |