Forum Discussion

Ayupchap's avatar
Ayupchap
Helper 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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
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

Ayupchap's avatar
Ayupchap
Helper III
8 years ago

Apologies for not making it clear, the example you use here is exactly how I have it, this is really amazing thanks so much!  This totally solves my problem