Forum Discussion
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,finished.)
Can you please guide me how to do it.
5 Replies
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-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualizationHi 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.It should fetch Min & Max dynamically.
Bucket = SWITCH ( TRUE (), 'Table 1' Surid In Min(Surid) && Max(Surid) BLANK () )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 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.
