Forum Discussion

MrCee's avatar
MrCee
Regular Visitor
7 years ago
Solved

DAX Measure - A Cumulative Running Total which returns a DATE when Target is achieved

Hi community,   Without using calculated columns as I would like to be able to pivot by project in Power BI using measures, I need to find a way to extract the exact date when the cumulative runni...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Do you want this?

FirstDateTargetReached =
MINX (
    DISTINCT ( Test[ID] ),
    CALCULATE (
        VAR TargetRunningTotal = 325
        VAR FirstDateOverTarget =
            FIRSTNONBLANK ( Test[Date], IF ( [Running total] >= TargetRunningTotal, 1 ) )
        RETURN
            FirstDateOverTarget
    )
)