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

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.

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.