Forum Discussion
Solved
If condition for DATE
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!
Ah, OK. Then try the same thing except as a number.
if Number.Mod([%DATE_KEY], 10000) = 1201 then [%DATE_KEY] else null
3 Replies
Try creating a custom column with this:
if Text.End([%DATE_KEY], 4) = "1201" then [%DATE_KEY] else nullHello AlexisOlson,
Thanks for Your help, unfortunately %DATE_KEY is integer (number) and it does not work with syntax Text.End.Ah, OK. Then try the same thing except as a number.
if Number.Mod([%DATE_KEY], 10000) = 1201 then [%DATE_KEY] else null
