Goal Visual

[Anonymous]

Hi!

I'm hoping to build a visual that tracks how well my client is meeting their goal. I have a row of data with a list of ID's and dates the ID had a code inputted. My data looks similar to below. I know how to make a constant line to show where my goal is, but I'd like to show over time how many ID's had their code inputted. So January 2020 had 6 ID's inputted, but by February 2020, I had 13 if that makes sense. Does anyone here by any chance know what DAX formula I would need to build up my chart?

ID	Date
1	1/20/2020
2	1/20/2020
3	1/20/2020
4	1/20/2020
5	1/20/2020
6	1/20/2020
7
8
9
10	2/3/2020
11	2/4/2020
12	2/5/2020
13	2/6/2020
14	2/7/2020
15	2/8/2020
16	2/9/2020
17
18
19
20	4/2/2020
21	4/2/2020
22	4/2/2020
23	4/2/2020
24	4/2/2020
25	4/2/2020
26	4/2/2020
27	4/2/2020
28	4/2/2020
29
30
31

[Anonymous]

Yes, exactly! Thank you so much, @VijayP !

[VijayP]

you are welcome @Anonymous I Appreciate your Kudos as well , Just press the 👍.Thanks!

[VijayP · Accepted solution]

 @Anonymous  Is this what  you would like to visualise?! pbix is attached here