Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gokul
Helper IV
Helper IV

Custom column based on same column values

how to create Custom column based on same column values using between operator ?? 

example:i have a column with values range from 0 to 10..i wanted to create custom column based on the condition.(ie).0-5 as custom column and 5 -10 as other custom column.. 

2 ACCEPTED SOLUTIONS
Sean
Community Champion
Community Champion

If I understand this right you may be overthinking this.

Just a simple if statement would do.

You may have to change this a bit but here it is depending on where you want the 5 included 

Custom Column =
IF ( Table[Column] < 6, "0-5", "6-10" )

Good Luck! Smiley Happy

View solution in original post

nmck86
Post Patron
Post Patron

I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.

 

Screen Shot 2018-09-27 at 10.07.26 PM.png 

 

View solution in original post

3 REPLIES 3
nmck86
Post Patron
Post Patron

I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.

 

Screen Shot 2018-09-27 at 10.07.26 PM.png 

 

Sean
Community Champion
Community Champion

Yes that works too! In fact that’s what I would do too! Smiley Happy

Sean
Community Champion
Community Champion

If I understand this right you may be overthinking this.

Just a simple if statement would do.

You may have to change this a bit but here it is depending on where you want the 5 included 

Custom Column =
IF ( Table[Column] < 6, "0-5", "6-10" )

Good Luck! Smiley Happy

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.