Combining Dates to Make Chart

[wlj22]

I am trying to make a chart with some of the same dates and each date equals 1. I want to combine the same dates and have it add them all up.

EXAMPLE:

1/1/18
1/1/18
1/1/18
1/2/18
1/2/18

So I want to combine the dates into a chart row and the column be the number of date's combined (1/1/18 = 3)

 

[sandy666]

you mean like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]date[/td][td][/td][td=bgcolor:#70AD47]date[/td][td=bgcolor:#70AD47]Count[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

01/01/2018​

[/td][td][/td][td=bgcolor:#E2EFDA]

01/01/2018​

[/td][td=bgcolor:#E2EFDA]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

01/01/2018​

[/td][td][/td][td]

01/02/2018​

[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

01/01/2018​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

01/02/2018​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

01/02/2018​

[/td][td][/td][td][/td][td][/td][/tr]
[/table]
with PowerQuery aka Get&Transform

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"date", type date}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"date"}, {{"Count", each Table.RowCount(_), type number}})
in
    #"Grouped Rows"[/SIZE]

 

[wlj22]

Yes like that, Thank you.

 

[sandy666]

You are welcome
Have a nice day