If condition for DATE

[Dom87326]

Hello, 

I am having some difficulty of If condition result.

I have two columns:

• %DATE_KEY int type, which has many non unique rows with dates looking back 5 years, format is always yyyymm&"01".
• Year End calculated column based on condition to show only year end results (see example below), if year is yyyy&"12"&"01" then %DATE_KEY else is blank.

Many thanks in advance for any help!

[AlexisOlson]

Try creating a custom column with this:

if Text.End([%DATE_KEY], 4) = "1201" then [%DATE_KEY] else null

[Dom87326]

Hello @AlexisOlson,  

Thanks for Your help, unfortunately %DATE_KEY is integer (number) and it does not work with syntax Text.End. 

[AlexisOlson · Accepted solution]

Ah, OK. Then try the same thing except as a number.

if Number.Mod([%DATE_KEY], 10000) = 1201 then [%DATE_KEY] else null