Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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" ),
", "
)
User | Count |
---|---|
70 | |
46 | |
21 | |
21 | |
15 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |