Adjustment of formula

[TH123]

Hi, im fairly new to Power Bi and need some assistance with an adjustment of a formula please

My formula is as follows:

Days trading formula = IF('Data for Tableau'[Days trading 1/3 volume]=">=0",'Data for Tableau'[Days trading 1/3 volume]="<=2.09999","1 day")
            = IF('Data for Tableau'[Days trading 1/3 volume]=">=2.1",'Data for Tableau'[Days trading 1/3 volume]="<=5.09999","2 to 5 days")
            = IF('Data for Tableau'[Days trading 1/3 volume]=">=5.1",'Data for Tableau'[Days trading 1/3 volume]="<=15.09999","5 to 15 days")
            = IF('Data for Tableau'[Days trading 1/3 volume]=">=15.1",'Data for Tableau'[Days trading 1/3 volume]="<=30","16 to 30 days")
            = IF('Data for Tableau'[Days trading 1/3 volume]=">=30","30 plus days")

Im getting the following "error" message though

DAX comparison operations do not support comparing values of type Number with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

Could anyone please assist

Thank you

[erikajain02]

You can try something like :

Days trading formula = IF('Data for Tableau'[Days trading 1/3 volume] >=0  &&  'Data for Tableau'[Days trading 1/3 volume] <=2.09999 ,"1 day")
     ....

[TH123]

Thank you Erikajain02

i adjusted as you suggested and im now getting the following pop up 

Too few arguments were passed to the IF function. The minimum argument count for the function is 2.

[erikajain02]

Days trading formula = IF('Data for Tableau'[Days trading 1/3 volume] >=0  &&  'Data for Tableau'[Days trading 1/3 volume] <=2.09999 ,"1 day", IF(Data for Tableau'[Days trading 1/3 volume].....

Did you tried like this....?

Can u upload ur sample sheet..

[TH123]

This is now my updated formula

Days trading formula = IF('Data for Tableau'[Days trading 1/3 volume]>=0 && 'Data for Tableau'[Days trading 1/3 volume]<=2.09999,"1 day"
= IF('Data for Tableau'[Days trading 1/3 volume]>=2.1 && 'Data for Tableau'[Days trading 1/3 volume]<=5.09999,"2 to 5 days"
= IF('Data for Tableau'[Days trading 1/3 volume]>=5.1 && 'Data for Tableau'[Days trading 1/3 volume]<=15.09999,"5 to 15 days"
= IF('Data for Tableau'[Days trading 1/3 volume]>=15.1 && 'Data for Tableau'[Days trading 1/3 volume]<=30,"16 to 30 days"
= IF('Data for Tableau'[Days trading 1/3 volume]>=30 && "30 plus days"

[erikajain02 · Accepted solution]

Try this : 

Days trading formula = IF('Data for Tableau'[Days trading 1/3 volume]>=0 && 'Data for Tableau'[Days trading 1/3 volume]<=2.09999,"1 day",
IF('Data for Tableau'[Days trading 1/3 volume]>=2.1 && 'Data for Tableau'[Days trading 1/3 volume]<=5.09999,"2 to 5 days",
 IF('Data for Tableau'[Days trading 1/3 volume]>=5.1 && 'Data for Tableau'[Days trading 1/3 volume]<=15.09999,"5 to 15 days",
 IF('Data for Tableau'[Days trading 1/3 volume]>=15.1 && 'Data for Tableau'[Days trading 1/3 volume]<=30,"16 to 30 days",
 IF('Data for Tableau'[Days trading 1/3 volume]>=30 , "30 plus days")))))

[TH123]

Works perfectly!

Thanky you so much!!!