Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 va...
DAX
  • Anonymous's avatar
    Anonymous
    5 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you very much friend ! You're the best ! I was going crazy with this !!!!!