SIMPLE IF BASED ON TODAY AND ADD COLUMN - variant data error??

[holeinone10]

Expressions that yield variant data-type cannot be used to define calculated columns.

PAST DUE =

VAR CONTRACTDATE = 'SALES CONTRACTS'[Contract Start Date]

VAR THISMONTH = EOMONTH ( TODAY () , 0 )

VAR PASTDUE = CONTRACTDATE < THISMONTH

RETURN

IF ( CONTRACTDATE = THISMONTH , "CURRENT MONTH",

IF ( CONTRACTDATE < THISMONTH , "PAST DUE",

CONTRACTDATE

)

)

[Anonymous]

columns must be the same data type throughout. You are trying to mix Text with, presumably, a date. Knowing that, what would your ideal scenario be?

[TomMartens]

Hey,

I'm not sure about the data type of the column '...'[Contract Start Date] but I assume it's of the datatype date or datetime.

As you return either the texts "CURRENT MONTH" or "PAST DUE" you should use the DAX formula FORMAT(..,) to convert the  column '...'[Contract Start Date] into a text like so:

FORMAT(CONTRACTDATE, "YYYY-MM-DD")

Hopefully this is what you are looking for.

Regards,
Tom

[holeinone10 · Accepted solution]

Such a simple answer.  Yes, that worked but didn't truly solve my problem.   I'm trying to use a contact card marked as past due also as a filter/toggle for a table on the same page listing all the open contracts. 

Is monitoring past due (orders, contracts, shipments) best done as a measure or calcuated column in the represented tables or even as a column in a seperate date table?