Generate series function using with measure is giving value until 5739 and not beyond

Hi sutanukadas,

If the theoretical premium can be calculated using columns available in the data source, the following Power Query logic can be used to generate a series:

let
    Source = ...,
    MaxPrem = List.Max(Source[base_net_premium]) * (1 + List.Max(Source[upper_bound_rating_factor]) / 100),
    Step = MaxPrem / 100,
    Series = List.Generate(
        () => 0,
        each _ <= MaxPrem,
        each _ + Step
    ),
    SeriesTable = Table.FromList(Series, Splitter.SplitByNothing(), {"Premium"})
in
    SeriesTable

This script calculates the maximum premium based on column values and generates a list of values from 0 to that maximum, incremented by a defined step.

Limitations:

Power Query cannot evaluate DAX measures or respond to user interactions such as slicers.
If the maximum value depends on dynamic context or user selections, Power Query is not suitable. In such cases, DAX with GENERATESERIES is the appropriate solution.