Forum Discussion
VeeExcelLearn
Mar 22, 2022Brass 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
- 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/- VeeExcelLearnBrass ContributorTerribly sorry. I posted it in that forum you suggested.