Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Goal Visual Pt 2

Hi! 

 

I'm hoping to build a visual that tracks how well my client is meeting their goal. TI 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 compared to how may I needed inputted in the beginning. So January 2020 had 6 ID's inputted, so I had 25 leftover by the end of January 2020 without the dates. Does anyone here by any chance know what DAX formula I would need to build up my chart?  VijayP  so helpfully created a cumulative visual yesterday here, but I would like to go backwards this time. So in this case, I had 31 ID's in total in the beginning, and I would like to show how long it is taking my client to input the remaining ID's. I'd like all 31 ID's to have dates in the end, which will be future dates. I hope this makes sense, but please let me know if it doesn't.

 

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 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Actually, I got it from combining your answer with another formula! 

    CALCULATE(COUNTROWS(DATA), ALLSELECTED(DATA))-CALCULATE(COUNT(data[Date]),FILTER(ALL(data),data[Date]<=MAX(data[Date])))

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak , thanks for responding! I'd essentially like to show the opposite of the cumulative chart. So I'd start off with 31 in the beginning of January 2020, moving to 25 in the end of January 2020 (6 ID's created with January 2020 dates), then 18 by the end of February 2020. I'd eventually like all codes to have their dates filled. Hopefully that makes better sense!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        To give a better idea, I'd like to make a chart similar to this, so in the end I'd have 18 ID's remaining without dates.

         

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous 

    To get the future Dates you need to have an assumption How long they may take and what are the trigger points to input the Code by customer. Based on that we can forecast the date when approximately the user going to input the date and we can create a custom column in Power Query