Forum Discussion
Power BI get one value from duplicates
Hi there,
I do have data as followed...
Reference Number Amount
A123 100
A123 100
A123 100
A124 200
A125 300
--------------------------------
Total 800
I would like to have data as showed in the below
Reference Number Amount
A123 100
A124 200
A125 300
--------------------------------
Total 600
Thank you
Hi Anonymous
If you want to change the dataset model, you could go to Edit queries->Home->remove rows->remove duplicates.
If you want to keep your original table and get a table structure like this to build a visual.
You could create a new table with this formula
Table 2 = SUMMARIZE(ALL('Table'),[number],[amount])Table Table2
Best Regards
Maggie
1 Reply
Hi Anonymous
If you want to change the dataset model, you could go to Edit queries->Home->remove rows->remove duplicates.
If you want to keep your original table and get a table structure like this to build a visual.
You could create a new table with this formula
Table 2 = SUMMARIZE(ALL('Table'),[number],[amount])Table Table2
Best Regards
Maggie