cancel
Showing results for
Did you mean:
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?

Regards,

Nawaz

1 ACCEPTED SOLUTION
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/

2 REPLIES 2
Super User III
``Conditional_Column = IF([Ranking] > 10 && [Ranking] < 50, [Some Value])``
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/

Announcements

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

#### Microsoft named a Leader in The Forrester Wave

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

#### 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 Solution Authors
Top Kudoed Authors