Forum Discussion

Isambard's avatar
Isambard
Icon for Helper I rankHelper I
2 years ago
Solved

Power Query Custom Column with Data Source

Hi,   I'm hoping this is really easy for someone with more experience than me. I'm taking data from a few dozen excel spreadsheets, each with a 20 named tables. I have set this up in power query an...
Need Help
  • Minseven07's avatar
    Minseven07
    2 years ago

    I see. Can you get your data in a folder then filter on that specific excel file? If yes, you will have access to the folder path and the file name.

     

     

Minseven07's avatar
Minseven07
Frequent Visitor
2 years ago

I see. Can you get your data in a folder then filter on that specific excel file? If yes, you will have access to the folder path and the file name.

 

 

  • Isambard's avatar
    Isambard
    Icon for Helper I rankHelper I
    2 years ago

    This works perfectly. Thank you.