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

Thank you for your help again Amit :). 

I have found the solution I needed :).

 

Best regards

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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
      Not applicable
      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.