Current Month Slicer

I have been working a lot in Microsoft Power BI recently and came across an interesting problem. The filters and slicers available don't offer a good way to set dynamic values. This makes it difficult to create a dashboard that shows data from the current month without manually updating the report every month with the current dates. While trying to find a way around this I found an interesting work around here: https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442.

The author of the solution, greggyb, created a list of dates and through various columns designated if those dates were in the current month. Unfortunately, his solution used a set of static dates, which I found less than ideal. I have developed a different solution that generates the list of dates going back one year from the current date. Here is the code that will generate the required table.

let Source = List.Dates( DateTime.Date(Date.AddYears(DateTime.LocalNow(), -1)) ,365 ,#duration(1,0,0,0) ), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}), Year = Table.AddColumn(#"Changed Type", "Year", each Date.Year( [Date] )), MonthNumber = Table.AddColumn(Year, "MonthNumber", each Date.Month( [Date] )), MonthIndex = Table.AddColumn(MonthNumber, "MonthIndex", each let FirstYear = List.Min( MonthNumber[Year] ) ,Mult = [Year] - FirstYear ,Index = 12 * Mult + [MonthNumber] in Index), Month = Table.AddColumn(MonthIndex, "Month", each Date.ToText( [Date], "yyyy MMM" )), MonthName = Table.AddColumn(Month, "MonthName", each Date.ToText( [Date], "MMMM" )), CurrentMonth = Table.AddColumn(MonthName, "CurrentMonth", each Date.IsInCurrentMonth( [Date] )), MonthSlicer = Table.AddColumn(CurrentMonth, "MonthSlicer", each if [CurrentMonth] then "Current Month" else [Month]), #"Changed Type1" = Table.TransformColumnTypes(MonthSlicer,{{"Year", Int64.Type}, {"MonthNumber", Int64.Type}, {"MonthIndex", Int64.Type}, {"Month", type text}, {"CurrentMonth", type logical}, {"MonthName", type text}, {"MonthSlicer", type text}}) in #"Changed Type1"

Use this code to create a table. You must also create a relationship between the Date column on this table and the column containing the date in the table that you want to filter. Then create a slicer using the Months column.

Note that the table will be generated whenever the data source is updated, so this solution works best with a data source that is updated on a regular basis.