Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Goal Visual

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?

 

IDDate
11/20/2020
21/20/2020
31/20/2020
41/20/2020
51/20/2020
61/20/2020
7 
8 
9 
102/3/2020
112/4/2020
122/5/2020
132/6/2020
142/7/2020
152/8/2020
162/9/2020
17 
18 
19 
204/2/2020
214/2/2020
224/2/2020
234/2/2020
244/2/2020
254/2/2020
264/2/2020
274/2/2020
284/2/2020
29 
30 
31 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Yes, exactly! Thank you so much, VijayP !

    • VijayP's avatar
      VijayP
      Community Champion

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