Creating funnel charts from data with different dates

[Anonymous]

I was recently asked to create a funnel chart for the below scenario:

ToDo Items --> Applications --> Approved --> Funded 

There can 1 or more 'ToDo Items' for one application.

Each item has a 'Item Created Date' and each application has a 'App Submitted Date'.

Below is the measure I created for 'ToDo Items' but I am unable to create a funnel due different dates being associated with different columns.

ToDo Items = CALCULATE([Total Items], FILTER('Table',
'Table'[CreatedDate] >= MIN(dCalender[Date]) && 'Table'[CreatedDate] <= MAX(dCalender[Date])
)) 

Also, below is a sample table structure of the data set.

ItemId	AppId	Item Created Date	App Submitted Date	IsApproved	IsFunded
1	11	1/1/2019	12/1/2018	1	0
2	11	1/2/2019	12/1/2018	1	0
3	11	1/3/2019	12/1/2018	1	0
4	22	1/4/2019	12/2/2018	0	0
5	22	1/5/2019	12/2/2018	0	0
6	33	1/6/2019	12/10/2018	1	1
7	44	1/7/2019	12/11/2018	1	0
8	55	1/8/2019	12/12/2018	0	0
9	66	1/9/2019	12/21/2018	1	1
10	66	1/10/2019	12/21/2018	1	1

Can someone please help me create the measures for these metrics?

[v-yuta-msft]

@Anonymous ,

Below is the measure I created for 'ToDo Items' but I am unable to create a funnel due different dates being associated with different columns.

ToDo Items = CALCULATE([Total Items], FILTER('Table',
'Table'[CreatedDate] >= MIN(dCalender[Date]) && 'Table'[CreatedDate] <= MAX(dCalender[Date])
)) 

---

Could you please clarify more details about "due different dates being associated with different columns"? If possible, could you also share the expected result table?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.