Forum Discussion
Incorrect Results using DAX
Hello folks, I have a table in which there are three columns. First column is Order Status which has either of the two values Delivered or Not Delivered. The second column, Delivery date, which has ...
Good post. You provided an explanation and photo to show the problem.
--
I 'suspect' that the dates that are failing are being converted to the incorrect date format (UK or US settings) because the example shows a 30th July 2018 failing but all the ones that look ok in the picture have months and days of values less than 12 (so they would be legitimate dates in UK or US settings (though it's important to get the correct transformation because 07/08/18 and 08/07/18 are legitimate dates but not the same date.
--
You can convert text to date with (right-click column header Change Type->using Locale). You do this before any error steps. You can't do it after an error occurs.