Last 3 Months Slicer

[JakubHa]

Hi,

I`m trying to create a Slicer with Last Month, Last 3 months and Overall.

I tried one Dax formula described here: Power BI – Time Period Slicer for Last 7 Days,Last 30 Days.. – Analytics Avenue

DatePeriod =
UNION (
ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today()-07+1,today()) ), 'Date'[Date]),"Period","Last 07 Days") ,
ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today()-14+1,today()) ), 'Date'[Date]),"Period","Last 14 Days") ,
ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today()-30+1,today()) ), 'Date'[Date]),"Period","Last 30 Days") ,
ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today()-90+1,today()) ), 'Date'[Date]),"Period","Last 90 Days") ,
ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date'), 'Date'[Date]),"Period","Overall")
)


But it doesn`t work for me. My dates are formated as only M+Y (no days):

01.01.2015 00:00:00

01.02.2015 00:00:00

<tbody>
</tbody>

Do you know any solution or workaround?

Many thanks,
Jakub

 

[gazpage]

I would use a disconnected slicer.

https://powerpivotpro.com/2013/08/moving-averages-controlled-by-slicer/

The above link shows how to use the slicer to put a number of months into the formula. That may work for you, but if not you can create a table like

Selection Number
Last Month 1
Last 3 Months 2
OVerall 3

Then create a measure for each option and the overall measure looks like

Switch([Number], 1, [Measure 1], 2, [Measure 2], 3, [Measure 3])