# Measure/Column selection functions

| NAME                                                                                                                      | DESCRIPTION                                                                                |
| ------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------ |
| [GET](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/get)                                   | Returns the value in the index of the list                                                 |
| [GETCOLBETWEENPERIODS](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/getcolbetweenperiods) | Fetch column list within a period range                                                    |
| [GETLOCALELABEL](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/getlocalelabel)             | Defined translations based on Power BI language settings                                   |
| [GETMEASUREBYINDEX](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/getmeasurebyindex)       | Returns measure values based on the specified index                                        |
| [SELECT](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/select)                             | Returns the range of cells between the start and end columns of a specified measure        |
| [SELECT\_BYINDEX](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/select_byindex)            | Returns an array of measure values by selecting columns based on their numerical positions |
| [TABLE](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/table)                               | Formats the data in each cell and arranges items as rows/columns                           |