Hey. So basically I want to do something where the last two columns of a table in power query will have their average taken. This is what it currently looks like:
https://gyazo.com/aa664bf02d6b17f65761ee745428b163
Does anyone know how I can stop the hardcoding of the Week 38 and Week 39, to instead just reference the last two columns of the previous step? Thanks.
I have attached a sample file if it's of any use.
Oh, I also have an issue with reordering the columns too because the advanced editor hardcodes the order, so when new weeks gets added, the order get's messed up unless you go back and adjust (not the end of the world, but a bit annoying, and it would be nice to avoid this issue). Thanks.
Bookmarks