PQ - Median of dates

Median of dates

	B	C	D	E	F	G
2	Date	Value	Countif		Date	Median
3	19/04/2020	1	1		19/04/2020	4.5
4	19/04/2020	2	2		20/04/2020	2.5
5	19/04/2020	3	3		21/04/2020	3
6	19/04/2020	4	4		22/04/2020	2
7	19/04/2020	5	5
8	19/04/2020	6	6
9	19/04/2020	7	7
10	19/04/2020	8	8
11	20/04/2020	9	1
12	20/04/2020	10	2
13	20/04/2020	11	3
14	20/04/2020	12	4
15	21/04/2020	13	1
16	21/04/2020	14	2
17	21/04/2020	15	3
18	21/04/2020	16	4
19	21/04/2020	17	5
20	22/04/2020	18	1
21	22/04/2020	19	2
22	22/04/2020	20	3

Code:

---

=COUNTIF(B$3:B3,B3)

---

Code:

---

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Value", Int64.Type}}),
    Group = Table.Group(Type, {"Date"}, {{"Median", each List.Median([Countif]), type number}})
in
    Group

---