Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI get one value from duplicates

Hi there,   I do have data as followed...   Reference Number     Amount      A123                               100 A123                                100 A123                                ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Please refer to the snapshot below. 

    1. Select the two columns with "CTRL";

    2. Remove duplicates.

    Power-BI-get-one-value-from-duplicates

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please refer to the snapshot below. 

1. Select the two columns with "CTRL";

2. Remove duplicates.

Power-BI-get-one-value-from-duplicates

 

Best Regards,
Dale