Forum Discussion
vtilokani
2 years agoRegular Visitor
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 ...
HotChilli
2 years agoCommunity Champion
"but it dosent seem to work" - explain this please. I can't help if you don't provide detail.
--
If the data is not good quality you are building on shaky ground so it doesn't matter if there are 5 rows or 100,000, it needs to be fixed.
- vtilokani2 years agoRegular Visitor
I'm sorry for being vague and not to the point.
When I use the option of change data type from Text to date/time in the power query editor, some of the dates are being converted but many are appearing as "Error". when I click on the error mesage I get the
following message/
following