Improvement Methods for the Response Performance of the Custom Measure (One-Month Demand Total)

■Issue

The response performance of the custom measure "One-Month Demand Total" is poor.

When this measure, or another measure that references this measure, is included in a table, the table takes a long time to display and eventually times out.

■Details

The details of the custom measure are described below.

We are currently considering ways to improve the performance of this measure, and we would like to hear from anyone who has experience creating a custom measure with similar requirements.

In addition, we would appreciate any advice regarding modifications that could improve performance, such as reducing the number of Lead function calls or handling leap years more efficiently.