Forum Discussion

aaftab42's avatar
aaftab42
Frequent Visitor
1 year ago

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...
Need Help
Ashish_Excel's avatar
Ashish_Excel
Solution Supplier
1 year ago

Hi,

Show the expected result very clearly.

manoj_kumar95's avatar
manoj_kumar95
New Member
1 year ago

I have attached the screenshots and pbix file. I need to get the correct running max. But y using the above formula i am not getting.

In this example see the dailycummulativeprofit and RunningMaxProfit 

1st image when not sorted

2nd image when dailycummulative profit sorted ascending

3rd image when dailycummulativeprofit column sorted descending 

in all these three cases the running max is changing dynamically but in my case it isnt changing it is giving a constant value all over the rows.

I am again attaching my power bi file once please refer to it and please help me out.

Link:- https://drive.google.com/file/d/19TmkeaslWT-KueSMjnDZO3QVjVOl0ApP/view?usp=sharing

 

when not sorted

 

When cummulativeprofit sorted ascending

 

When cumulativeprofit column sorted descending

 

  • Ashish_Excel's avatar
    Ashish_Excel
    Solution Supplier
    1 year ago

    Hi,

    You have still not answered my previous question - you do not show the expected result at all.  Anyways, based on whatever my understanding is, download the PBI file from here.