Forum Discussion
Secondary filter
Dear all, I'm doing something terribly wrong. So, I have 2 tables: Inventory of 2022 with following columns: Calendar Week, Plant, Stock value; year (all rows with the same value 2022) Inventor...
Herllo Anonymous ,
You can append queries which means you make these two tables as one table, then use the year column to filter between years.
check append queries concept https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Thank you. I append both tabels but now, It will show me for calendar week 1 a sum of both values (2022+2023)
I need to have them in paralel (1 graph for 2022 and one for 2023( in order to compare the evolution from oane year to second one on the same week.