Forum Discussion

jefflynn's avatar
jefflynn
Frequent Visitor
2 years ago

Concatenate not working

I want to concatenate Employee Number (text) with SelectedEndYearMeasure. Selected End = SELECTEDVALUE ('Cal End'[End Date]) - measure SelectedEndYearMeasure = Year([Selected End]) My colum...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

jefflynn If that is a calculated column, probably won't work as measures don't generally work in calculated columns. You could use a measure form like: 

EmployeeSelectedEndYearMeasure = CONCATENATE(MAX('Raw Data'[Employee Number]), [SelectedEndYearMeasure]

jefflynn's avatar
jefflynn
Frequent Visitor
2 years ago

Still not working: