Forum Discussion
PROBLEMS WITH IF AND DATEDIFF
Hello friends ! I have a question: I need to make a DAX function that shows me an interval of days between two dates and at the same time filters the values since I don't want it to show me this value if a certain field is empty. The function I have created is:
However, when I run it I get the following error:"Expressions that produce Variant data types cannot be used to define calculated columns." If I only do the "DATEDIFF" function I have no problems, but there is no way to filter it. Do you have any idea that I'm
doing wrong? I understand that it should be possible ... Thank you!
Hi Anonymous ,
Try this
Dias_Vencimiento = IF('Consulta SLA'[dld_chk_codigo] = "",DATEDIFF('Consulta SLA'[FechaVencimiento_ML].[Date],TODAY(),DAY),BLANK())
or
Dias_Vencimiento = IF('Consulta SLA'[dld_chk_codigo] = "",DATEDIFF('Consulta SLA'[FechaVencimiento_ML].[Date],TODAY(),DAY),0)
DATEDIFF returns an interger. Here in your formula you are trying to return an integer as well as text hence the Expressions that produce Variant data types cannot be used to define calculated columns." error
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
2 Replies
Hi Anonymous ,
Try this
Dias_Vencimiento = IF('Consulta SLA'[dld_chk_codigo] = "",DATEDIFF('Consulta SLA'[FechaVencimiento_ML].[Date],TODAY(),DAY),BLANK())
or
Dias_Vencimiento = IF('Consulta SLA'[dld_chk_codigo] = "",DATEDIFF('Consulta SLA'[FechaVencimiento_ML].[Date],TODAY(),DAY),0)
DATEDIFF returns an interger. Here in your formula you are trying to return an integer as well as text hence the Expressions that produce Variant data types cannot be used to define calculated columns." error
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)