Concatenation of Year and format as YYYY

adam_macs — Thu, 13 Oct 2022 16:47:16 GMT

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")

Re: Concatenation of Year and format as YYYY

tamerj1 — Thu, 13 Oct 2022 16:56:26 GMT

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" ), ", " )

topic Concatenation of Year and format as YYYY in DAX Commands and Tips

Concatenation of Year and format as YYYY

Re: Concatenation of Year and format as YYYY