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)
Inventory of 2023 with following columns: Calendar Week, Plant, Stock value; year (all rows with the same value 2022)
I need to create a visual with both values to compare them.
It works fine *I can add s slicer wor Calendar week) but I need to have a slicer to remove the value for 2022 or 2023 and I can't get this.
I also tried to create another lookup table with 3 columns: Calendar week, Year 2022 (filled with only one value 2022) and Calendar week, Year 2023 (filled with only one value 2023) and a relation 1 to 1 with the inventory 2022 and 2023 tables. Still, I can't get the desired results.
can you please help me? i'm a beginner.
Thank you!
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 💡
3 Replies
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 💡