Forum Discussion
Create a new row for a range of two columns PowerQuery
Hello everyone,
I have a question to perform a transformation in PowerQuery. I explain:
I have a table with two columns that have a range of "accounting accounts" and I would like it to generate a row for each account that is in the range.
Example:
New rows:
0 609001
0 609002
0 609003 ... 0 609999
Is it possible to perform this?
Best regards
msantin , Use List.Numbers to create a new column and then expand that
Power Query- List.Numbers: https://youtu.be/7_4V_Om-FEk
List.Dates example - Same will trye for List.Numbers
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-months-between-range-df019cec823b
1 Reply
- amitchandak
Super User
msantin , Use List.Numbers to create a new column and then expand that
Power Query- List.Numbers: https://youtu.be/7_4V_Om-FEk
List.Dates example - Same will trye for List.Numbers
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-months-between-range-df019cec823b