Forum Discussion

vtilokani's avatar
vtilokani
Regular Visitor
2 years ago

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 ...
Need Help
HotChilli's avatar
HotChilli
Community Champion
2 years ago

Please refer to my previous response. Get these fields changed to a date or datetime type in Power Query.  Very straightforward.  If there is an error, there may be a problem with data quality and you can fix it there.

  • vtilokani's avatar
    vtilokani
    Regular Visitor
    2 years ago

    HotChilli I tried using your solution but it dosent seem to work. There is a lot of inconsistency in the raw data for the columns we are trying to solve the problem for. The raw data is close to 100,000 rows.