How to add text to blanks when using 'YEAR'

[MeganMarkey]

Hi! I have a column in which I'm pulling the year from another date column. What I need is for the blank columns to have the text 'In Flight' - Is anybody able to help me do this?

[Kedar_Pande]

@MeganMarkey 

Calculated Column:

Year_Display = IF(ISBLANK(YEAR([DateColumn])), "In Flight", YEAR([DateColumn]))

If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

[Zanqueta · Accepted solution]

Hello  @MeganMarkey

You want to display the year from a date column, but if the date is blank, show the text "In Flight".
This can be done with an IF condition in DAX or in Power Query.

Try it:

YearOrCreation =

IF(

    ISBLANK('YourTable'[DateColumn]),

    "In Flight",

    FORMAT(YEAR('YourTable'[DateColumn]), "0")

)

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[MeganMarkey]

That worked perfectly! Thank you so much!