Forum Discussion
VeeExcelLearn
Mar 22, 2022Copper Contributor
PowerQuery Help
I think this is possible but I have no idea how to accomplish this. What I am trying to do is repeat a row. If you look under, the second screenshot below line description column, you will see headers like Salaires & Wages. They are always identified as LineSubSequence 0 and maybe this is the key. Is there a way to make the Salaries and Wages go on every single line blow the subaccounts.
So it would look like this:
Before: | ||
Salaries & Wages | ||
6005000000 | Productive Wages | |
6005050000 | Productive Premium | |
6025000000 | CTO Wages | |
6025050000 | CTO_COB Payout | |
6040000000 | Non-Productive Wages | |
After. | ||
Salaries & Wages | 6005000000 | Productive Wages |
Salaries & Wages | 6005050000 | Productive Premium |
Salaries & Wages | 6025000000 | CTO Wages |
Salaries & Wages | 6025050000 | CTO_COB Payout |
Salaries & Wages | 6040000000 | Non-Productive Wages |
2 Replies
Sort By
- Julian_SharpLearn ExpertYou have posted on the Microsoft Learn board which is all about exams, certification and training.
You might have better luck on the Power BI community board https://community.powerbi.com/- VeeExcelLearnCopper ContributorTerribly sorry. I posted it in that forum you suggested.