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],"
    ")
v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi JinDR ,
Thanks for reaching out to Microsoft Fabric Community.

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

 

Thanks Anonymous and bhanu_gautam for your valuable inputs and prompt response.