How to calculate received and completed tasks according to month/date range in Power BI

Question

I have multiple tasks table and have do relationship to link to my Unique Date Table (date purpose) and dORSID table (Each unique agent)

• All tasks table relationship to my Date table and dORSID table Photo

• Upload Date and CompleteDate is different Photo

All tasks table Upload Date is link to my Date table. so no I would like to create a visual table with Total Tasks received and Total Tasks Completed, so how can I write the DAX in Power BI to identify the tasks received and tasks completed is according to the date

The below is Expected result from Excel

Excel formula: =COUNTIFS(Data!$BC:$BC,'SL%'!A2,Data!$BG:$BG,"Completed")

Photo