Concatenation of Year and format as YYYY

[adam_macs]

Hi, i have created a measure that concatenates the assessment years that customers purchase into one value. The problem is I would like to format the result to show as YYYY instead of DD/MM/YYYY like below.

I have tried formatting the "Finance_Sales[AcademicYear]" column as YYYY as well as adding a FORMAT formula to the measure, however this didn't seem to do anything.

Any help much appreciated

CombinedAssessmentYears = 
FORMAT(CONCATENATEX (
    FILTER (
        SUMMARIZE (
            Finance_Sales,
            Finance_Sales[CustomerName],
            Finance_Sales[AcademicYear]
        ),
        Finance_Sales[CustomerName] = EARLIER ( Customers[CustomerName] )    ),
    Finance_Sales[AcademicYear],
    ", "),"YYYY")

[tamerj1 · Accepted solution]

Hi @adam_macs 

please try

CombinedAssessmentYears =
CONCATENATEX (
    FILTER (
        SUMMARIZE (
            Finance_Sales,
            Finance_Sales[CustomerName],
            Finance_Sales[AcademicYear]
        ),
        Finance_Sales[CustomerName] = EARLIER ( Customers[CustomerName] )
    ),
    FORMAT ( Finance_Sales[AcademicYear], "YYYY" ),
    ", "
)