Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@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
@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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |