If statement error "Dax comparison operators do not support comparing values of type text

[appsac1]

I am receiving an error on trying to create an IF statement:

Resoultion Time Status =

IF(

[Granulated] = "OPEN" , "OPEN",

IF(

[Granulated] <=1, "24 hours",

IF(

[Granulated] <=2, "48 hours",

IF(

[Granulated] <=3, "72 hours",

IF(

[Granulated] <=4, "96 hours",

">5 days")))))

Any help with this would be of really appreciated.

[v-zhangti]

Hi, @appsac1 

You can try the following methods.

Resoultion Time Status = 
IF(
[Granulated] = "OPEN" , "OPEN",
IF(
VALUE([Granulated]) <=1, "24 hours",
IF(
VALUE([Granulated])<=2, "48 hours",
IF(
VALUE([Granulated])<=3, "72 hours",
IF(
VALUE([Granulated]) <=4, "96 hours",
">5 days")))))

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The issue is with my Granulated measure not working, because of which the results for Resolution time status shows just as 24 hours and Open.
Below is the measure that I created for Granulated:

I don't have an option to upload my pbix file on the forum, I am sharing the workspace link 
https://app.powerbi.com/groups/me/reports/080c3ce8-6d27-4120-8721-e6824f854b43/ReportSection

[Anonymous]

I fixed this temporarily by replacing open in the Granulated formulae by 0
Old - Granulated = IF(ISBLANK('April Tickets'[Resolved time].[Date]),FORMAT( "open" , ([Resolved time].[Date] - [Created time].[Date])*1.))

New - 

Granulated = IF(ISBLANK('April Tickets'[Resolved time].[Date]), 0 , DATEDIFF('April Tickets'[Created time],'April Tickets'[Resolved time],DAY))

But I want open and not o to show in my table and I am unable to find a way to have both text and int. The format option isn't working.

[ryan_mayu]

@appsac1 

we can only have one type for one column. So we can't have text which is Open and number which are 1,2,3,4.

may be you can try this:

Resoultion Time Status =

IF(

[Granulated] = "OPEN" , "OPEN",

IF(

[Granulated] *1<=1 ."24 hours",

IF(

[Granulated] *1<=2, "48 hours",

IF(

[Granulated] *1<=3, "72 hours",

IF(

[Granulated] *1<=4, "96 hours",

">5 days")))))

[Anonymous]

Thank you so much it worked, could you explain the logic behind adding [Granulated] *1?

[ryan_mayu]

@Anonymous  

did that to transfer text to number and then we can do the comparation.

[Anonymous]

I tried adding it to the table visual, but it only gives me two column fields "open" and "24 hours" as below:

[ryan_mayu]

@Anonymous 

could you pls provide the sample data?

[Anonymous]

I am unable to upload the file, but below is the workspace link:
https://app.powerbi.com/groups/me/reports/080c3ce8-6d27-4120-8721-e6824f854b43/ReportSection

[ryan_mayu]

@Anonymous 

I can't open the report. you can provide some dummy data or just a part of your real data and paste it in the reply.

[Seanan]

Hi @appsac1 

Could you please post the Grandulated measure code.

[Anonymous]

Sure, below is the measure code

Granulated = IF(ISBLANK('April Tickets'[Resolved time].[Date]),FORMAT( "open" , ([Resolved time].[Date] - [Created time].[Date])*1.))