Bucket wise sales

Anonymous 

Create a separate table (Bucket) as below.

Then create this calculated column in your table. 

Bucket = 
VAR X = Sales[Amount]
VAR Filtered =
    FILTER (
        'Bucket',
        VAR Y = 'Bucket'[Upper] RETURN 'Bucket'[Lower] <= X
            && IF ( ISBLANK ( y ), TRUE (), Y >= X )
    )
RETURN
    MAXX ( Filtered, Bucket[Sales Bucket] )

Appreciate with kudos.

Please mark as solution if this resolves your problem.

Thanks

Hi Anonymous ,

If "Sales" is a column, then you can add a calculated column in your table like so:

Bucket =
SWITCH (
    TRUE (),
    [Sales] >= 0
        && [Sales] <= 30, "0-30",
    [Sales] >= 31
        && [Sales] <= 60, "31-60",
    [Sales] >= 61, ">61"
)

Or, create a measure:

Bucket =
SWITCH (
    TRUE (),
    SUM ( 'Table'[Sales] ) >= 0
        && [Sales] <= 30, "0-30",
    SUM ( 'Table'[Sales] ) >= 31
        && [Sales] <= 60, "31-60",
    SUM ( 'Table'[Sales] ) >= 61, ">61"
)

If "Sales" is a measure, then create a measure like so:

Bucket =
SWITCH (
    TRUE (),
    [Sales] >= 0
        && [Sales] <= 30, "0-30",
    [Sales] >= 31
        && [Sales] <= 60, "31-60",
    [Sales] >= 61, ">61"
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.