LOOKUPVALUE from a Date column showing large whole number

[kkanda]

Hello All,

I am using a Card to indicate the Date on which a Notification is created when we select an Equipment in the table. The DAX expression is:

= LOOKUPVALUE(List_Notifications{Created_On}, List_Notifications[Equipment],Sel_Equipment,UNICHAR932))

Created_On column contains dates with formatting of "mm/dd/yyyy" and Sel_Equipment is calculated from another similar expression. 

The result displayed in the column is a large whole number and this changes when we select another equipment again giving a result of a large whole number.

If I change the result column to say [Created by], the card shows the correct result. I cannot understand how the large number is related to a date. 

Krishna

[AlexisOlson · Accepted solution]

Dates are stored internally as the number of days since 12/31/1899. For example, today (Aug. 6 2021) is represented as 44414.

You can manually format a number as date text with the FORMAT function. For example, 

FORMAT ( 44414, "yyyy-mm-dd" ) will return "2020-08-06"