Forum Discussion
volt26
Helper I
Helper IDAX formula that returns columns based on subcolumn's value from smallest to highest
Hello! I need to return columns but the data needed varies on a subcolumn named KEY. Each EVENT can have multiple KEY entries. If KEY is the lowest of EVENT, the formula needs to take the data fr...
Hi,
PBI file attached.
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Share data in a format that can be pasted in an MS Excel file.
volt26Helper I
Helper IHere it is :
| EVENT | KEY | START | MIDDLE | END |
| A | 1 | 50 | 6 | 18 |
| A | 2 | 23 | 31 | 41 |
| A | 3 | 45 | 18 | 13 |
| B | 1 | 72 | 65 | 4 |
| B | 2 | 9 | 17 | 90 |
| C | 1 | 35 | 76 | 43 |
| C | 2 | 8 | 14 | 21 |
| C | 3 | 66 | 67 | 98 |
| C | 4 | 85 | 5 | 26 |
It will most likely be possible to copy-paste it. 🙂
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.
- volt26
Thank you very much! This file does all I need.
If someone else use this, be aware that the smallest key is entered manually with a static value of 1. In my case, I didn't mention it but the key varies from event to event so I needed to change this static value for "Data[KEY]=MIN(Data[KEY])"Have a wonderful day!
- Ashish_Mathur
You are welcome.