Forum Discussion
Issue with Calculating Drawdown with Filters in Power BI
Hi Community Members, I'm currently working on a Power BI project and could use some guidance on optimizing my drawdown calculations. Here's a summary of my approach and the challenge I'm facing: C...
I am using the same formulas for cummulative sum and max but the cummulative max is not working i dont know the reason. it is taking the same values through out the data though the data is changed in asecnding or descding ordrer. Please help me with that.
I am attaching the project file, the screenshots and the formulas below.
Link:- https://drive.google.com/file/d/19TmkeaslWT-KueSMjnDZO3QVjVOl0ApP/view?usp=sharing
DailyCumulativeProfit =
CALCULATE(
SUMX(
FILTER(
ALL(trade_logs),
trade_logs[date] <= MAX(trade_logs[date]
)
),
trade_logs[pnl]
)
)
RunningMaxPnL =
CALCULATE(
MAXX(
FILTER(
ALL(trade_logs),
trade_logs[date] <= MAX(trade_logs[date]
)
),
[DailyCumulativeProfit]
)
)
Hi,
Show the expected result very clearly.