Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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")
Solved! Go to 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" ),
", "
)
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" ),
", "
)