Challenge

Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

1.project link

https://drive.google.com/file/d/1AazoZzMXkL--hnYDDFeU-S-zdgec2X4w/view?usp=drive_link

*=FILTER('Applicant Data'!H:H,'Applicant Data'!D:D="f")

=SORT(A2:A202449)

=UNIQUE(A2:A202449)

*=DSUM('Applicant Data'!1:1048576,"AMT_INCOME_TOTAL",'Applicant Data'!EC6:EC7)

=DAVERAGE('Applicant Data'!1:1048576,"AMT_INCOME_TOTAL",'Applicant Data'!EC6:EC7)

= DMAX('Applicant Data'!1:1048576,"AMT_INCOME_TOTAL",'Applicant Data'!EC6:EC7)

=DMIN('Applicant Data'!1:1048576,"AMT_INCOME_TOTAL",'Applicant Data'!EC6:EC7)

*=DCOUNT('Applicant Data'!1:1048576,"FLAG_DOCUMENT_2",'Applicant Data'!EC6:EC7)

=DCOUNTA('Applicant Data'!1:1048576,"FLAG_DOCUMENT_2",'Applicant Data'!EC6:EC7)

Ship work like this
in your own course.