Forum Discussion

ebachrach's avatar
ebachrach
Regular Visitor
8 years ago

Query that creates new rows which sum certain fields based on external grouping

Hi,   New to Power Query, I have searched but cannot determine how to accomplish my need. I have a table containing payroll data categorized by facility, payroll date, and department. Other fields...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ebachrach,

 

I think summarize function should suitable for your requirement to summarize records. Can you please share some sample data with detail calculate condition to test and coding formula?

 

Regards,

Xiaoxin Sheng

ebachrach's avatar
ebachrach
Regular Visitor
8 years ago

Hi @Xiaoxin

I have a workbook containing the data on tab PRHIST, and table tblReportSWDepartments on tab Tables. There are some supporting tables as well.  But how do I share the sample?

 

Thanks Elly

 

Anonymous wrote:

Hi ebachrach,

 

I think summarize function should suitable for your requirement to summarize records. Can you please share some sample data with detail calculate condition to test and coding formula?

 

Regards,

Xiaoxin Sheng

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI ebachrach,

     

    You can upload to onedirve or google drive, then share link here.

    Notice: do mask on sensitive data before sharing.


    Regards,

    Xiaoxin Sheng