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.