Forum Discussion
Solved
Data Formatting for Slicer
Hi All, TL;DR How can I create a slicer for both month and year? I'm a co-op student working on an accounting project for a company. The data that I am using is being pulled directly fro...
Hello MiekeV
If you apply a couple steps to your query you can get what you are looking for.
1. Unpivot value columns
2. Remove "Amount" from the month name
3. Add a Month-Year column
I have attached my sample file for you to take a look at.
Hello MiekeV
If you apply a couple steps to your query you can get what you are looking for.
1. Unpivot value columns
2. Remove "Amount" from the month name
3. Add a Month-Year column
I have attached my sample file for you to take a look at.
Sorry it took a while to get back to this! The "unpivot" function worked perfectly!
2 new columns were created, one for the month and the other with the values.
Thank you!
