Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @Labraham36 ,
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)
Hi @Labraham36 ,
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)
Thank you very much friend ! You're the best ! I was going crazy with this !!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |