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...
Just to add, to get the Total Future/ Past, I used:
=calculate(sum([Future Bookings]),filter(allexcept(leaveData, leaveData[Worker Name]),[Worker Name]=Earlier([Worker Name])))
So i have tried variations of this desperately trying to work it out, but alas that has (unsurprisingly) been unsuccessful!