Forum Discussion

Power_BI_Help's avatar
Power_BI_Help
Icon for Helper I rankHelper I
6 years ago
Solved

Calculated 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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI  Power_BI_Help 

    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

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

HI  Power_BI_Help 

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's avatar
Power_BI_Help
Icon for Helper I rankHelper I
6 years ago

D'oh, can't believe that was all I needed to do. So much faster and more scalable, thanks.