Forum Discussion

rodneyc8063_1's avatar
rodneyc8063_1
Helper V
5 years ago
Solved

Power Query M Code - {0}[Data] Meaning?

Apologies in advance for the cryptic forum title.   I am studying Power BI at the moment, and was going through this following article on Power Query M Code   https://docs.microsoft.com/en-us/pow...
Need Help
  • rodneyc8063_1's avatar
    rodneyc8063_1
    Helper V
    5 years ago

    Thanks so much for this!

     

    That article is exactly what I am looking for 🙂

     

    So to summarize, this is used for Power Query M language "cell navigation"

     

    Taken from the article: StepName{RowIndexNumber}[Column] and this specific RowIndexNumber is one that is automatically generated by Power Query. Power Query has its own index and it starts from 0, so if you’re trying to get the first row of a list or a table, you’d use {0}

     

    I was able to do further reading, and syntax wise its acceptable to either use 

     

    StepName{RowIndexNumber}[Column] or StepName[Column]{RowIndexNumber}

     

    These will both essentially produce the same result, but the difference is the sequence or order of steps. Either it can pull the record first, then the specific column OR it can just pull the column and then get the record. 

     

    Thanks for the clarification! Again much appreciated!