https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1989110#M43978 <P>Hi there. I think the troubleshooting is rather easy... I think there's a function that turns a date into its underlying float value representation (it could be datevalue or value... something of this kind, anyway). Use this function in another calculated column to see what error and where you get. Also, there might be a logical function that tells you whether something is a correct date or not. Use it to troubleshoot. You might use DAX Studio for this.</P> Fri, 30 Jul 2021 08:00:02 GMT Anonymous 2021-07-30T08:00:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1987482#M43926 Fri, 30 Jul 2021 08:45:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1987482#M43926 Casper1234 2021-07-30T08:45:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1987707#M43937 <P>I don't think it's enough to say that something is causing an error and expect people to troubleshoot. Would you please make it clearer? What error? Why don't you show the error? Don't be shy...</P> Thu, 29 Jul 2021 15:36:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1987707#M43937 Anonymous 2021-07-29T15:36:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1989110#M43978 <P>Hi there. I think the troubleshooting is rather easy... I think there's a function that turns a date into its underlying float value representation (it could be datevalue or value... something of this kind, anyway). Use this function in another calculated column to see what error and where you get. Also, there might be a logical function that tells you whether something is a correct date or not. Use it to troubleshoot. You might use DAX Studio for this.</P> Fri, 30 Jul 2021 08:00:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/deleted/m-p/1989110#M43978 Anonymous 2021-07-30T08:00:02Z