Forum Discussion
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...
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
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