Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
marcelodn
New Member

Two types of date In the one collumn

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")

marcelodn_0-1677343603295.png

 

marcelodn_1-1677343682215.png

 

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.

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.