Hello, I would like to calculate drawdown on trading account, quite easy in excel, not very easy in Power BI for me. I have following data set Trade No., Net profit and I would like to calculate Balance and Drawdown. Balance is simple running total, so it is not a problem. But I have no idea how to calculate drawdown – drawdown from previous highest high. Drawdown is calculated as Previous Drawdown plus Net Profit, but only if result is lower than 0 otherwise drawdown is 0. Example: Trade NoNet profitBalanceDrawdown110010002-5050-503-100-50-1504500-10055050-506501000710020008-100100-100950150-50102003500 Thank you for any help.

Hi jan1, You could do something similar to this (alter to match your table names etc). Create the following measures:(sample PBIX file here) NetProfit = SUM ( 'Trades'[Net profit] ) Balance = CALCULATE ( [NetProfit], FILTER ( ALL ( 'Trades' ), 'Trades'[Trade No] <= MAX ( 'Trades'[Trade No] ) ) ) High Water Mark = MAXX ( ADDCOLUMNS ( FILTER ( ALL ( 'Trades' ), 'Trades'[Trade No] <= MAX ( 'Trades'[Trade No] ) ), "Bal", [Balance] ), [Bal] ) Drawdown =[Balance] - [High Water Mark]

Calculating drawdown - running total with condition

Forum Discussion

Related content

Conditional formatting on calculated item in calculation group

conditional Formatting in Calculation Item

Drawdown Curve

Conditional formatting using multiple calculation groups

calculate max drawdown for multiple portflio