Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help Power query!!! New column with specific referenced cells

Hi everyone,   I have tried this multiple ways/times and am now getting a headache form banging my head against the wall 🙂 .   My issue is that I have a column taken from my source with multiple...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Glad to hear that you have found the solution. Could you share us your solution?

     

    In addition, you can add an index column to get what you want like so:

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Icey

     

    Yes, the solution started by me remebering that Power BI works in tables etc and not columns & rows like excel.

    So, 1st I set an index and filtered the data I wanted out relative to the 1st index rows[12,24,36,48,60]. Then I added a new index column to start from 1 on this filtered data and used this 'new' index to link the table to my other tables.

     

    Thanks for all your help everyone and interest 🙂

     

    Regards

     

    Franco.

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit

 

I had to change text to type whole number to avoid errors, but the new column just shows blank.

 

 

I just need to show the values at those specific cells(in the defined range) in a new column.

 

Regards

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit again! 🙂

I guess what I am trying to do is find the Power BI equivalent of the =index formula in MS Excel, which until now, I don't think there is a simple formula for as far as I can find.

 

Regards