Forum Discussion
Helper IIsInThisMonth,Quarter,Year ... IsInPrevious Month, Quart, Year
Please read this article - it should give you exactly what you want
Helper I*bump* while i appreciate the help from the last two users I really didnt get what I was looking for ... To clue you in, I am trying to create something like the picture below, where the user has the ability to simply press a button and pare down selections to WTD, Last Week, Last 7 Days, Current Week ... I just need to fill in the gaps for Current Month, Previous Month, Current Quarter, Previous Quarter ... I feel like someone had to do this before so I am hoping I can leverage without reinventing the wheel.
Thanks,
Dave
Solution SagePlease read this article - it should give you exactly what you want
- hansolo
- sdjensen
hansolo - the code he uses is M is the code created by and used by the Query Editor (Power Query). Chris is the master of all masters of M and he literally wrote the book about it. In the end of the article there is a link to a test file.
Go to the query editor and add a new blank query and then go to advanced editor on this new blank query here you can write the M code yourself.
If you need help with M functions you can go to this page.