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 II
Super User II

@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
Super User III
Super User III

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

@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.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors