Need to create Bucket based on Group

[PSan1979]

Hi Experts,

I have two tables (Table 1 and Table 2 in my data model and is joined by Surid). I want to vloop (if Surid from table 2 exist in Surid1 from Table1 then fetch SURID,Gender,Studying,finished.)

Can you please guide me how to do it.

[V-lianl-msft]

Hi @PSan1979 ,

Not very intelligent, but may be able to meet your needs.

Create an index column in the query editor, and then create a calculated column with dax.

Bucket = 
    SWITCH (
        TRUE (),
        'Table'[Index] < 5, "8320-8505",
        'Table'[Index] < 10, "8333-8524",
        BLANK ()
    )

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

[PSan1979]

Is It possible to create a separate table. and VLOOP Table2 from Table 1. if its matches then display value else blank

ID	COL1	COL 2
SURID1	XXX	1
SURID2	1	XXX

[V-lianl-msft]

Hi @PSan1979 ,

Unpivot then create a 1-* relationship with table2

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

[PSan1979]

It should fetch Min & Max dynamically.

Bucket = 
    SWITCH (
        TRUE (),
        'Table 1' Surid In Min(Surid) && Max(Surid)
        BLANK ()
    )

[amitchandak]

@PSan1979 , refer is these can help

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization