Hi
I need help trying to figure out how to repeat certain values in a column, repeating for each row. Please see below, an example of what I am looking for. The information is grouped by a ledger account number, followed by several transactions and then subtotaled. Then, the next account number starts and the transactions unders this group are also grouped and sub totalled.
I want to repeat the account number in a new column, such that every transaction (Row) is allocated to the respective account number. I have seen this done before using Data Transform in PowerBi, but just cant remember how the person did it.
Please let me know if anyone can help.
thanks.
| Date | Debit | Credit | GL Account (Column I need) | |
| 0010/000 : Interest Received | | | 0010/000 : Interest Received | |
| Opening Balance as at 01/03/19 | | | 0010/000 : Interest Received | |
| 11/03/19 | | 30 000.00 | 0010/000 : Interest Received | |
| 15/03/19 | | 20 000.00 | 0010/000 : Interest Received | |
| Closing Balance as at 31/03/19 | | | 0010/000 : Interest Received | |
| 0100/000 : Discount Received | | | 0100/000 : Discount Received | |
| Opening Balance as at 01/12/19 | | | 0100/000 : Discount Received | |
| 31/12/19 | | 20 000.00 | 0100/000 : Discount Received | |
| Closing Balance as at 31/12/19 | | | 0100/000 : Discount Received | |
| 0500/000 : Sales | | | 0500/000 : Sales | |
| Opening Balance as at 01/03/19 | | | 0500/000 : Sales | |
| 31/03/19 | | 25 000.00 | 0500/000 : Sales | |
| 31/03/19 | 150 000.00 | | 0500/000 : Sales | |
| 31/03/19 | | 50 000.00 | 0500/000 : Sales | |
| 2120/000 : Advertising | | | 2120/000 : Advertising | |
| Opening Balance as at 01/03/19 | | | 2120/000 : Advertising | |
| 01/03/19 | 500.00 | | 2120/000 : Advertising | |
| 01/03/19 | 700.00 | | 2120/000 : Advertising | |
| 01/03/19 | 8 866.00 | | 2120/000 : Advertising | |
| 01/03/19 | 11 721.33 | | 2120/000 : Advertising | |
| 05/03/19 | 15 904.33 | | 2120/000 : Advertising | |
| 08/03/19 | 20 087.33 | | 2120/000 : Advertising | |
| 08/03/19 | 24 270.33 | | 2120/000 : Advertising | |
| 08/03/19 | 28 453.33 | | 2120/000 : Advertising | |
| 08/03/19 | 32 636.33 | | 2120/000 : Advertising | |
| 15/03/19 | 36 819.33 | | 2120/000 : Advertising | |
| 19/03/19 | 41 002.33 | | 2120/000 : Advertising | |
| Closing Balance as at 31/03/19 | | | 2120/000 : Advertising | |
