Design Dax formula - with Multiple Ifs condition

Hi, PowerBIBeginer ;

1.The column in which we're trying to get this output is Text, such as "> 4 Hr"  and "> 48 hrs";Because your output result has characters and letters, it must be text. In order to maintain consistency, a column can only have one type, which requires that the output results are all text. Therefore, the initial int (24 * ap2) does not meet the requirements, resulting in an error.

2.If your [Time Taken]  data type = Decimal number  and Format = whole number . 

and Request type column data type  Text.

I tested it correct，However, this error is displayed because of the data type, which means that the text cannot be compared with the number. Through your description, I did not find the comparison between the number and the text. So I still hope to share your code  、 errors and some simple data screenshots without sensitive information . thanks .

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.