Forum Discussion
How do I create a column of data using a single cell of source data
You can do this in the Transform File. Make your next step after the source steps be = PreviousStepName[Column2]{0}. Name that step CustomerNumber. Then make your next step's formula like:
= StepNameBeforeTheLastStep
Now you have your original table, and the CustomerNumber as a variable. You can use CustomerNumber in an AddColumn step, and that formula would be:
Table.AddColumn(PriorStepName, "Customer Number", each CustomerNumber)
--Nate
Hello Anonymous ! I found a similar solution using Record.Field and pulling the recorded value into a custom column. I think your solution is very similar and like most things in Power BI, is one of many solutions to a problem. I got the Record.Field idea from the following website:
https://exceleratorbi.com.au/convert-a-cell-value-into-a-column-with-power-query/
This site is a bit dated and I am testing a more straightforward approach as I type but it seems like it is working.
Hello Anonymous . The refresh produced one value for customer number across all of my 2 dozen excel files. This value came from the very first file. I need the customer number to be syncronized to each individual file. I'll keep working on this and restore your recommendation if I can get it to work.