Solved: Re: Creating a number range between two values

Anonymous · ‎05-14-2019

how to create a range of values from a column

Example

numerical values

10

20

25

30

35

40

45

need ranges from 10 - 30 = 1

range from 31 to 40 = 2

range from 41 to 45 = 3

greater than 45 = 4

parry2k · ‎05-14-2019

@Anonymous add new column and use swtich function

Range = 
SWITCH( TRUE(),
Table[Number Value] > 45, 4,
Table[Number Value] > 40, 3,
Table[Number Value] > 30, 2,
Table[Number Value] > 9, 1
)

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎05-14-2019

@Anonymous add new column and use swtich function

Range = 
SWITCH( TRUE(),
Table[Number Value] > 45, 4,
Table[Number Value] > 40, 3,
Table[Number Value] > 30, 2,
Table[Number Value] > 9, 1
)

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.