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.
