measure that displays date base on year

[Eldren]

Hi everyone! I have this 2 columns in sa single table, ManufacturingDate and ProductionDate. I want to create a measure that will display the Value of ProductionDate when ManufacturingDate=1/1/1900 and display ManufacturingDate when its value is not equal to 1/1/1900. Thank you.

[Eldren]

Got it. Thank you. 

[BA_Pete · Accepted solution]

Hi @Eldren ,

This is quite row-level specific, so I would recommend doing this in a Power Query custom column:

if Date.Year([ManufacturingDate]) = 1900 then [ProductionDate] else [ManufacturingDate]

At a push, you could to it as a DAX calculated column:

adjustedDateColumn =
IF(
    YEAR(yourTable[ManufacturingDate]) = 1900,
    yourTable[ProductionDate],
    yourTable[ManufacturingDate]
)

If you really want to do this as a DAX measure, then it would be something like this, but I think you'd need to be quite careful about the filter context when you visualise it:

_adjustedDate =
VAR _manuDate = MAX(yourTable[ManufacturingDate])
VAR _prodDate = MAX(yourTable[ProductionDate])
RETURN
SWITCH(
    TRUE(),
    YEAR(__manuDate) = 1900, __prodDate,
    __manuDate
)

Pete