Newbie: Switch DAX Function for Dates

[Anonymous]

Evening All

I have a date column caleld Year Completed and  if there is no date then its not completed.

If there is a year mentioned ; then it displays that value

I wanted an option like so below which I would use in a slicer for grouping of Not Completed or whatever year it completes

Year Completed Group = Switch(true() ,
isblank(ADMIN_MASTER[Year Completed]) , "Project Not Completed",
ADMIN_MASTER[Year Completed] = 2023, "Completed in 2023",
ADMIN_MASTER[Year Completed] = 2024, "Completed in 2024",
ADMIN_MASTER[Year Completed] = 2025, "Completed in 2025",
"Project Not Completed") 

As you can see I have an error so Im doing something wrong?

Advice welcome.

Jimmy

[Anonymous · Accepted solution]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

@Anonymous    Apologies indeed I knew about the "some text" but I ahd some silly mistakes. All Good now.

Thanks for the advice.

Jimmy

[vicky_]

There's two ways to solve this:
change the type of the Year column to a number. This can be done in PowerQuery if it's just imported as part of a different dataset. If it's a calculated column, then you'll need to surround the final value with INT() or VALUE(). 

Or in the measure you've written above, change the 

ADMIN_MASTER[Year Completed] = 2023

to 

ADMIN_MASTER[Year Completed] = "2023"

Note there are quotes around the number.

The first method is better in my opinion, as it makes more sense for year to be an integer type.