Awesome tutorial. Would you please share your thoughts on this one. I guess it could be more robust building the logic for skipping dynamically the n rows until we find the month over the column 11, instead of using a proxy value over the column 2 which is more likely to be inconsistent and prone to break as we apply the transformation steps over other tables.
Thanks for watching the presentation! When you open the file, go to the "Home" tab and click "Transform data", so the Power Query editor opens. You will then be able to see the 2 queries.
We've added links to Alejandra's files to the event description, but here are the direct links: - Working Files: 1drv.ms/u/s!AuhhLgCXSCKKgZBjlZIVh2SAp_eu4w?e=lFvzt2 - Final Solution: 1drv.ms/u/s!AuhhLgCXSCKKgZBi5wPhVZu6cnH93g?e=41UOpt
Awesome tutorial. Would you please share your thoughts on this one. I guess it could be more robust building the logic for skipping dynamically the n rows until we find the month over the column 11, instead of using a proxy value over the column 2 which is more likely to be inconsistent and prone to break as we apply the transformation steps over other tables.
super❤
Glad you liked it Kebin! Cheers 😊
Get presentation with good tricks. PBIX file with the final solution is empty. Could you please re-upload? Thanks
Thanks for watching the presentation! When you open the file, go to the "Home" tab and click "Transform data", so the Power Query editor opens. You will then be able to see the 2 queries.
@@skillwavetraining . Ok i see the queries now. Thanks
Could you please share the file so we could follow along?
We've added links to Alejandra's files to the event description, but here are the direct links:
- Working Files: 1drv.ms/u/s!AuhhLgCXSCKKgZBjlZIVh2SAp_eu4w?e=lFvzt2
- Final Solution: 1drv.ms/u/s!AuhhLgCXSCKKgZBi5wPhVZu6cnH93g?e=41UOpt
@@skillwavetraining Thank you!