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

[UK_User123456]

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 

[Anonymous · Accepted solution]

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

[sakarim]

This works great! I am wondering if it is possible to show the text as a label on a bar chart. It appears when you select "show as a table" but not on the actual bar chart. Any thoughts?