How do I Expand Table Column

[Anonymous]

Hi folks!  I am trying to duplicate a query created by a former colleague.  The first line of code connects to a folder containing 23 excel files of idential layout/format.  I can easily duplicate this first line of code and the next three lines.  FWIW, the only column of data left after the third line of code is an expandable column, see below:

 

I cannot figure out where the commands exist in Query Editor that produce line 5 of the code, see below.  Any help is much appreciated!

 

[tackytechtom]

Hi @Anonymous ,

Try to click on the icon in the top right and then click ok:

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Hello @tackytechtom  and thanks for the prompt reply.  I perfromed the expansion as you suggested but received a completely different looking DAX code for the expansion than what my former colleague produced.  My code:

Former colleagues code:

I noticed that my fomer colleagues code refers to Sample File (5) which resides in a helper query.  My code does not refer to a helper query.  Is this a clue?

[Vijay_A_Verma]

You can't easily duplicate the code when combining files from the folder. You will need experience before doing this. What I will suggest that you watch this video and then do merging on your own. Whatever code is generated, change the code as per your friend's. 

This will introduce you to the concept of Transform file as well.