Two types of date In the one collumn

[marcelodn]

I have a column created that should return a date. But for some reason, it is returning the date with 2 different types of dates. When I filter appears 2 filter options with the same date. The problem is, I have a related calendar db, and it's working only for one of the date types. I'll try to explain more:

for example below, I filtered 1 date and it pops up 2 options.
(The date format is "dd/mm/yyy")

For all the columns that impact this final column, I put the same data type and also the same format (shortdate). 

A_Entrega = if(factDevices[G_DataEntregaKA] <> BLANK(), factDevices[G_DataEntregaKA],
    LOOKUPVALUE(factRentOrders[Data inicial], factRentOrders[Ordem de locação],factDevices[Ordem de locação]))

Below the formula you are using. At first the error occurs only for when date comes from the column (G_dataEntregaKA), for the other is functioning normally.