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?
User | Count |
---|---|
30 | |
27 | |
25 | |
21 | |
21 |