Forum Discussion
Solved
Cross-table data manipulation in Power Query
Hi all Having a headache with something, just looking for some advice. I have a data model and there are two relevant tables to this problem. STUDENTS table lists all students at a school, and YE...
Just in case someone else stumbles across this I solved this by merging the tables into a new table, doing my filtering based on year, and then removing the years column again and deduping the table to get back down to one line per student in a new STUDENTS table that only contains students from the last 5 years.
I have no idea if this is best practice, but at least it pushes the workload onto the Microsoft servers instead of local machines and it achieves the result I wanted so...
Hi crispybits77 ,
Rather than making us imagine what you want to achieve, please post a usable sample data (not an image) that covers your use case and your expected result using that sample data.