Forum

Transform master da...
 
Notifications
Clear all

Transform master data

2 Posts
2 Users
0 Reactions
167 Views
(@mohammed)
Posts: 1
New Member
Topic starter
 

Hi,

i have a specific question about power querry and breaking out master data. 

I Would like to use Power querry to create a report and a Dashboard for an organisation which has a 5 business line, each composed of 2 to 5 cost center. A data i have is for 2 fiscal year : 24 columns for periodic amount plus others columns for actual, budget and other calculations. Its totalise almost 1340 columns. First column is a catégories of revenus and expenses for each cost center. 

I would like to transform a data to create a dynamic report, by selected period, year, cost center, business line and total. 

I’ve try some transformation and modelling with no success. 

thank you very much.

 
Posted : 29/06/2020 11:55 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Mohammed,

Welcome to our forum! It sounds like your data is in the wrong format. You can use Power Query to unpivot it so that it's in a tabular format. This format can then be analysed and summarised in PivotTables etc. to automate your reporting.

I hope that points you in the right direction.

Mynda

 
Posted : 30/06/2020 4:33 am
Share: