cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UK_User123456
Resolver I
Resolver I

If statement to check if a value is between two values and return text

Hi All,

 

Probably really simple but I am trying to return text if a number falls between two values as follows:

 

Difference
3
100
500
320
410
210

 

If one of the above falls between 0 - 365 return "Active"

 

I tried using the following DAX statement, but it wont return a text

 

IF(AND([Difference] > 0 , [difference] < 365 ), "Active" )

 

TIA 

1 ACCEPTED SOLUTION
sreenathv
Solution Sage
Solution Sage

Result = IF(and(Table1[Difference]>0 , Table1[Difference]<365),"Active",BLANK())

View solution in original post

1 REPLY 1
sreenathv
Solution Sage
Solution Sage

Result = IF(and(Table1[Difference]>0 , Table1[Difference]<365),"Active",BLANK())

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.