Calculating Drawdown and MaxDrawdown

DAX DAX Calculations
21

All lot of the formula techniques are similar to before but the bug change was creating a calculated table to complete a lot of the hard work first.

See below

image
image.png780×602 21.7 KB

Also the solution is iterating through Dates, rather than the Trade table which becomes far more efficient.

See how you go with this

22

Hey Sam, I spent a couple hours validating the calculations and they look spot on! I’m going to spend more time tomorrow reviewing this in detail. I’ll provide more feedback tomorrow!