Why do I get an error when I use the LEN in this IF ??

[Quentin_Ernesti]

Hi,

Any idea why Power BI tells me that I have an error when I use this formula for a new column? 

date_rappel_inbound - Heure =

IF(

    LEN('hubspot deal'[date_rappel_inbound]) < 11,

    "short",

    "long"

)

It works when I replace "short" and "long" by 0 and 1, but for some reason it seems that when I try to get some text as an output, it gives me an error saying that there is something wrong with my calculated column.

I m really lost here, thanks !

[Quentin_Ernesti]

Nevermind, I rearranged the field inside the visual and suddenly it works fine....

[Ahmedx]

try this

IF(
LEN(MAX('hubspot deal'[date_rappel_inbound])) < 11,
"short",
"long"
)

[Quentin_Ernesti]

Sadly it didn't work.

I really don't get why it seems to think of it as a number, when it's clearly a text and the data type is a text.

[Quentin_Ernesti]

Hi Vicky,
Thanks for your answer, but the field that shows "Somme de da..." is actually the field that I am showing in the formulae and the one that I am indeed trying to solve! 😉

[vicky_]

I suspect that it's because the Somme de date_ra... measure relies on the calculation for date_rappel_inbound - Heure. So you will need to fix that measure for it to work.