Forum Discussion

PSan1979's avatar
PSan1979
Icon for Helper II rankHelper II
6 years ago

Need to create Bucket based on Group

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,fi...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

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

It should fetch Min & Max dynamically.

 

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