Forum

Expanding GLaccount...
 
Notifications
Clear all

Expanding GLaccounts by cost centres

6 Posts
2 Users
0 Reactions
135 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I would like to expand particular GL accounts by cost center as attached.

Please see expected result for reference and please help me doing that in Powerquery.

thank you.

Regards,

Aye

 
Posted : 25/04/2020 3:44 am
(@mynda)
Posts: 4764
Member Admin
 

Hi Aye,

See session 7.08 Add Rows. You can use the List.Number function as described here to generate a list of the facility numbers. 

I hope that points you in the right direction.

Mynda

 
Posted : 25/04/2020 6:17 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Many thanks, Mynda.

Regards,

Aye

 
Posted : 26/04/2020 12:35 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Mynda,

Can I expand with my own list instead of system generated list.

as attached, I made a list for facility numbers. I would like to expand my accounts according to facility numbers. as expected result.

how can I combine the two (Account table and Facility list) in power query.

Thank you.

Regards,

Aye

 
Posted : 26/04/2020 9:30 pm
(@mynda)
Posts: 4764
Member Admin
 

Yes, just as you would for a list you generate. I see you already converted the Facility table to a list, so now in the Account query add a custom column with the following formula:

=#"Facility"

Then expand the List to Rows.

Mynda

 
Posted : 27/04/2020 6:22 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Many thanks, Mynda.

This is perfect and so easy 🙂

Regards,

Aye

 
Posted : 28/04/2020 6:55 am
Share: