Forum Discussion

nisuomi's avatar
nisuomi
Icon for Resolver I rankResolver I
9 years ago

Cumulative sum when target achieved, get the date

Hi community,   I am facing a bit of a problem with my DAX. Or more specifically the lack of my DAX skills maybe at this point ant the logic is not in my brain..    I have a situation where we fo...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Is your Target always 100 or is it variable?

 

Essentially I would create a measure to apply a filter show rows where t_cumu is higher than the target and then grab the MIN(Date).

 

I've hardcoded the target but this could be made dynamic

 

 

Target Hit Date = CALCULATE(
					MIN(MyTable[Date]),
					FILTER(
							MyTable,
							MyTable[t_cumu] > 100
						)
					)

 

  • nisuomi's avatar
    nisuomi
    Icon for Resolver I rankResolver I
    9 years ago

    Hi Phil_Seamark !

     

    Yes the Target is at the moment only 100 so no need to use any variable here.

    I tried the calculation that you provided, but for some reason it returns a (blank) value for me. Any idea what could cause this?

     

    Thank you for your help already :) I try, if I can solve it somehow on my own also .. 

     

     

     

    Cheers,

    Niko

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      What is the name of your table?

      • nisuomi's avatar
        nisuomi
        Icon for Resolver I rankResolver I
        9 years ago

        Phil_Seamark it is named like DataTable.

        I replaced MyTable with that but did not work..