Forum Discussion

Anthony67's avatar
Anthony67
Frequent Visitor
6 years ago
Solved

Concatenate returning distinct values

Hello everyone, I have a measure in a table that gets the concatenation of values in a different table: ScheduelStartDates = CONCATENATEX('tct_schedule',DAY('tct_schedule'[CourseStartDate]),",",D...
  • lbendlin's avatar
    lbendlin
    6 years ago

    Try to use VALUES() over the course start date column. 

     

    ScheduleStartDates = CONCATENATEX('tct_schedule',VALUES(DAY('tct_schedule'[CourseStartDate])),",")

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Try to use VALUES() over the course start date column. 

 

ScheduleStartDates = CONCATENATEX('tct_schedule',VALUES(DAY('tct_schedule'[CourseStartDate])),",")

  • Anthony67's avatar
    Anthony67
    Frequent Visitor
    6 years ago

    Hi,

     

    You're a champion!! Thank you.