Forum Discussion

JinDR's avatar
JinDR
Frequent Visitor
1 year ago
Solved

Lookup Function with Multiple results

I have a table which has multiple values such as below: Client Reason Date A Error Jul 1 A Wrong Data Jul 8 B Error Jul 10 B Wrong Input Jul 20 B Wrong Data Jul 22 ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    JinDR  , By using the below measure the unique reasons can be displayed.

    Measure = CONCATENATEX('Client','Client'[Reason],"
    ")
Anonymous's avatar
Anonymous
Not applicable
1 year ago

JinDR  , By using the below measure the unique reasons can be displayed.

Measure = CONCATENATEX('Client','Client'[Reason],"
")