Forum Discussion

Ayupchap's avatar
Ayupchap
Icon for Helper III rankHelper III
8 years ago
Solved

Issue with groups

HI all hope somone can help I have a large dataset and I was trying to create groups for one of the columns. I could create them in the grouping page as lists fne but when I press OK it shows the wor...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Ayupchap,

     

    That case, would you please make the sample data more clear and more readable? Would you please show me the sample table as what I have posted above?

     

    If I understand corrently, value like "Grade 6 ELA #1 16 Book 1" is stored in a signle column, right? I think it won't matter. You can split it to multiple columns.

    Column2 = LEFT(Table3[Column1],17)
Column3 = RIGHT(Table3[Column1],LEN(Table3[Column1])-LEN(Table3[Column2]))

     

    Best regards,

    Yuliana Gu

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago

When you say group, are you referring to the "Group By" option in the query editor, or the New Group option when selecting a field?

 

Also, how large is your dataset?

  • Ayupchap's avatar
    Ayupchap
    Icon for Helper III rankHelper III
    8 years ago

    Hi there

     

    New group option is what I meant, when you right click on a selcted field.  The dataset is about 250,000 records pulling from a ODBC linked database table.  

    • RMDNA's avatar
      RMDNA
      Icon for Solution Sage rankSolution Sage
      8 years ago

      I've definitly seen Power BI hang when using the field group option with that many records.

       

      Why not move to a custom column in Query Editor or a calculated column?

      • Ayupchap's avatar
        Ayupchap
        Icon for Helper III rankHelper III
        8 years ago

        Is this possible when I have different names which I need to match together?  Some have 2 books some don't  the assessments I want to match would be like the following

         

        Grade 6 ELA #1 16 Book 1

        Grade 6 ELA # 1 16 Book 2

        Grade 6 ELA #2 16 Book 1

        Grade 6 ELA # 2 16 Book 2

        Grade 6 ELA # 3 16

        Obviously I want to combine those that say #1 together and #2 together. The final one in the example listed just has to be on its own, no book. There are many assessments like this above for numerous grades etc.  Can a custom column help with this?  I just have no idea how it would.