Formatting the result of a SELECT

Hello!

I have the following case.

I have a column with a list of dates, let's say it exists in column Visit[assigned_date]

I'm trying to build a Enum that shows a unique list of dates formatted with month and year: "mm/yyyy"

In that line I tried the following:

SELECT(TEXT(DATE(Visit[assigned_date])),([customer_id] = [_THISROW].[customer_id]),TRUE)),"MMM")

but it didn't work.

Is it possible to format the output of a SELECT function? or should I break this down into two different columns?

0 5 163
5 REPLIES 5
Top Labels in this Space