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,
PBI file attached.
Hope this helps.
volt26Helper I
Helper IThank 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.