DAX Help to For Drawdown
Good Day I am trying to calculate the "Drawdown" row as per the below data table example. As you can see the TOTAL CUMATIVE Formula used gives the Cumulative by Year resulting in a value of $186 I am trying to Acheive the "DrawDown" calculation based on WIN(+) and NO WIN(-) by year Hence starting from $186 (Total Budget) - "NO WIN" + "WIN" So in the below example: =186-[5+0]-[25+0]-[15+0]-[5+16]-[15+10]-[30+0]-[25+15]-[15+10] Hence, i need support to develop the above measure Cumulative Drawdown by Year Thanks! Total_Cumulative_Overall = CALCULATE( [Budget], FILTER( ALLSELECTED('_Calendar'), ISONORAFTER(_Calendar[Date], MAX(_Calendar[Date]),DESC) ) )
