Forum Discussion
Solved
Populate first value based on group
Hi Dear,
Could you please help me on below Dax logic?
I have a table with 3 collumns Location, device and Topo.
| LOCATION | DEVICE | TOPO | Collumn 1 | |
| 140059 | 1 | 2G | ||
| 140059 | 2 | 4G | ||
| 140059 | 4 | 4G | ||
| 140534 | 1 | 4G | ||
| 140534 | 3 | 2G | ||
| 140534 | 4 | 2G | ||
| 140701 | 1 | 2G | ||
| 140701 | 2 | 4G |
I wonder how can I do to populate de collumn 1 with the folowing example:
| LOCATION | DEVICE | TOPO | Collumn 1 |
| 140059 | 1 | 2G | 1 |
| 140059 | 2 | 4G | 1 |
| 140059 | 4 | 4G | 1 |
| 140534 | 3 | 2G | 3 |
| 140534 | 4 | 2G | 3 |
| 140701 | 1 | 2G | 1 |
| 140701 | 2 | 4G | 1 |
| 140703 | 2 | 2G | 2 |
| 140703 | 3 | 4G | 2 |
as you can see for each location I need to populate the collumn 1 with the lowest value of collumn device.
Result = CALCULATE(MIN('Table2'[Device]),ALLEXCEPT(Table2,'Table2'[Location]))
I find the solution, I´m sorry. tks for all
1 Reply
Result = CALCULATE(MIN('Table2'[Device]),ALLEXCEPT(Table2,'Table2'[Location]))
I find the solution, I´m sorry. tks for all