Forum Discussion
Anonymous
3 years agoNot applicable
Index according to value
Hello, I am trying to create different index groups depending on the Value and the Hours columns. To better understand I added an example. Initial Table: So I used Power Query to group by Ta...
- 3 years ago
Anonymous
pls see the attachment below
Anonymous
3 years agoNot applicable
Hello ryan_mayu,
Thank you for all your help...
It still did not work, if I add more values to the file you sent it works only for a few values.
Data added:
| 4 | 01/10/2021 | 02:10:00 | 9 |
| 4 | 01/10/2021 | 02:20:00 | 9 |
| 4 | 01/10/2021 | 04:10:00 | 9 |
| 4 | 01/10/2021 | 05:30:00 | 9 |
| 4 | 01/10/2021 | 05:40:00 | 9 |
| 4 | 01/10/2021 | 05:50:00 | 9 |
| 4 | 01/10/2021 | 06:30:00 | 9 |
| 4 | 01/10/2021 | 07:00:00 | 9 |
| 4 | 01/10/2021 | 07:20:00 | 9 |
| 4 | 01/10/2021 | 07:30:00 | 9 |
| 4 | 01/10/2021 | 07:40:00 | 9 |
| 4 | 01/10/2021 | 18:10:00 | 9 |
| 4 | 01/10/2021 | 18:20:00 | 9 |
| 4 | 01/10/2021 | 18:30:00 | 9 |
| 4 | 01/10/2021 | 19:00:00 | 9 |
| 4 | 01/10/2021 | 19:10:00 | 9 |
| 4 | 01/10/2021 | 19:20:00 | 9 |
Sorry to keep asking this, I'm having a hard time with it.
Thank you again.
ryan_mayu
Super User
3 years agothe output looks like correct. What's the expected output?