Forum Discussion
Extracting Duplicate Distinct Data
Hi All, I'm not very good at eplaining so i'll attach a picture. I am trying to extract duplicate data from one table and get it into a distinct list in another table. I have a table with...
Hi,
You should have a master list of all your employee names from both Tables (you can create that by appending the two tables, removing all other columns and then removing dulicates). Then create a relationship between the two source Tables and the unique employee Table. In your visual, drag the employee names from the unique employee table. Lastly, write these 2 measures
Measure1 = SUM(Data[Total Future])
Measure2 = SUM(Data[Total Past])
Hope this helps.