Forum Discussion
Power_BI_Help
Helper I
Helper ICalculated Column: Rolling Maximum by Label (or high water mark)
Hello Community, I have been calculating Drawdown = Current Value / Rolling Maximum (or high water mark) for each different label. I have this DAX formula working, however, it is very laggy to pr...
For your case, i would suggest you use Date hierarchy in the x-axis, since there are to many day in the axis, so the calculation will be very slow, so you'd better just use Year-quarter-Month in the visual, do not use dim day any more.
here is sample pbix file, please try it.
Regards,
Lin
amitchandak
Super User
Super UserPower_BI_Help , Not clear. Can you share sample data and sample output in table format?
You can try like this
lastnonblankvalue(Date'[Date], max('Daily Ledgers'[Portfolio - Equity Total EOD ($)]))
refer:https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak