Forum Discussion

Valnus's avatar
Valnus
Icon for Helper II rankHelper II
4 years ago
Solved

Create a band between two colums

Hi 

I have two colums as per below 

 

I want to create a band 

 

 

 

start_score
0
1
11
21
31
41
51
61
71
81
90
   end_score
0
10
20
30
40
50
60
70
80
90
100


I need to group them like this to show a users score

Score

0-0

1-10

11-20

21-30

31-40

41-50

51-60

61-70

71-80

81-90

90-100

 

I can't get the group by to work properly, 

 

Any suggestions ? 

Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi Valnus ,

     

    You can easily get this done in Power Query Editor in Power BI Desktop.

    Consider the following input data:

    Select both the columns in the data above --> right-click --> merge columns

    Once you hit merge columns, a new window appears. Give the relevant details as shown below and hit Ok.

    You will get the required details:

    In case you want this as an additional column to you existing 2 columns --> then make sure to duplicate your both columns first and then follow all the steps.

     

1 Reply

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    4 years ago

    Hi Valnus ,

     

    You can easily get this done in Power Query Editor in Power BI Desktop.

    Consider the following input data:

    Select both the columns in the data above --> right-click --> merge columns

    Once you hit merge columns, a new window appears. Give the relevant details as shown below and hit Ok.

    You will get the required details:

    In case you want this as an additional column to you existing 2 columns --> then make sure to duplicate your both columns first and then follow all the steps.