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