Forum Discussion
hansolo
Helper I
Helper IIsInThisMonth,Quarter,Year ... IsInPrevious Month, Quart, Year
I used a great solution from elliotdixon as described below to build slicers based on week to date, current week and last week .. http://community.powerbi.com/t5/Desktop/Display-this-week-amp-thi...
Please read this article - it should give you exactly what you want
hansoloHelper I
Helper I
sdjensen
Solution Sage
Solution Sagehansolo - 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.