cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nawaz
Helper I
Helper I

conditional column for certain interval

Hi all,

 

I would like to display values in a column that lie in a certain interval, e.g. less than 50 AND greater than 10.

Conditional_Column = IF([Rankig]<50 & [Rankig]>10)

Note: Ranking is a column

 

Can I solve this using a conditional column?

 

Thanks in advance for your help.

Regards,

Nawaz

1 ACCEPTED SOLUTION
DataZoe
Super User
Super User

@Nawaz To create that one in DAX it's

 

Conditional_Column = IF([Ranking] < 50 && [Ranking] < 10, [Some Value], blank())

 

or 

 

Conditional_Column = IF(AND([Ranking] < 50, [Ranking] < 10), [Some Value], blank())

 

Logical functions (DAX) - DAX | Microsoft Docs

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

2 REPLIES 2
CNENFRNL
Community Champion
Community Champion

Conditional_Column = IF([Ranking] > 10 && [Ranking] < 50, [Some Value])
DataZoe
Super User
Super User

@Nawaz To create that one in DAX it's

 

Conditional_Column = IF([Ranking] < 50 && [Ranking] < 10, [Some Value], blank())

 

or 

 

Conditional_Column = IF(AND([Ranking] < 50, [Ranking] < 10), [Some Value], blank())

 

Logical functions (DAX) - DAX | Microsoft Docs

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!