Forum Discussion
Helper ICalculated Column: Rolling Maximum by Label (or high water mark)
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
Super UserPower_BI_Help , it can if the ID is present in the visual table
Else put in calculate and force Id using values(Table[ID])
Helper Iamitchandak
The function seems to grab the last non blank value (i.e. the same day) not the maximum value of all the dates leading up to that day. I attached a photo with the formula you've stated and the incorrect graph it creates when compared to the correct chart on the left. The calculated column does the same. It is not an all time high value for the column up to that date....
Ideas?
I appreciate the comments.
v-lili6-msftCommunity Support
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
- Power_BI_Help
D'oh, can't believe that was all I needed to do. So much faster and more scalable, thanks.