Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Reuben
Helper III
Helper III

best way to organize input table in excel

Hi guys,

What do you think is the best way to organize an excel input data table:

First option

Location                     KPI                                                     Date         Value

AA                  Energy consumption - Kwh         30/06/2019      100

AA                   Energy Consumption  - Kwh      31/07/2019      90

AA                   Energy Consumption - Kwh       31/08/2019     80

BB                    Energy consumption - Kwh         30/06/2019      50

BB                  Energy Consumption  - Kwh      31/07/2019      60

BB                 Energy Consumption - Kwh       31/08/2019     50

AA                  Water consumption - m3           30/06/2019      100

AA                   Water consumption - m3                31/07/2019      90

AA                   Water consumption - m3                 31/08/2019     80

BB                    Water consumption - m3                   30/06/2019      50

BB                  Water consumption - m3                31/07/2019      60

BB                 Water consumption - m3                 31/08/2019     50

 

Second option

 

Location                        Date                   Energy Consumption KWh       Water Consumption m3

AA                           30/06/2019                                           100                            100

AA                         31/07/2019                                               90                                  90

AA                        31/08/2019                                                 80                                   80

BB                           30/06/2019                                                50                                50

BB                        31/07/2019                                                  60                                 60

BB                      31/08/2019                                                  50                                  50

 

Thanks for your advice.

 

Regards

Rbn

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi, @Reuben 

Both options are good choices. They can switch back and forth in edit queries by pivot column or unpivot columns.

And as far as I can see, I prefer the first option. Since it is easy for filter and classify KPI in the report.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @Reuben 

Both options are good choices. They can switch back and forth in edit queries by pivot column or unpivot columns.

And as far as I can see, I prefer the first option. Since it is easy for filter and classify KPI in the report.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thanks @v-lili6-msft for you advice

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.