Spreadsheet: 715432d1611699516-power-query-custom-formula-not-working-for-1-single-condition-dummy-data-excel-forum-pq-issue
Sheet: Table1

[NAME] | [NAME] | [NAME] | [NAME] | Media Group
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
2020-12-25 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | Letter, [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
2020-12-25 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Letter, MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
2020-12-25 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | Letter, [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
2020-12-25 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Letter, MP Letter and Call
2020-12-25 00:00:00 | 2020-12-25 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | Letter, MP Letter, [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Call Only
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-26 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-25 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 2021-01-25 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-11-25 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | MP Letter and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-21 00:00:00 | 2021-01-25 00:00:00 | [NAME] and Call
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-26 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-25 00:00:00 | Call Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 1900-01-01 00:00:00 | [NAME] Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
2020-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | Letter Only
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00