This month, Last month, Next month

[Anonymous]

Hi,

I have a normal date table and I am wanting to add a slicer that says 'This Month', 'Last Month', Next Month'.

What would be the easiest way to achieve this in dax?

Thanks

Chris

[Anonymous · Accepted solution]

Measure:

Today = 
DATE ( YEAR ( NOW () ); MONTH ( NOW () ); 1 )

Column:

Months = 
IF (
    AND ( [Date]>=DATE ( YEAR ( NOW () ); MONTH ( NOW () )-1; 1 ) ;[Date]<[Today] );
    "Last Month";
    IF (
        AND ( [Date]>=DATE ( YEAR ( NOW () ); MONTH ( NOW () ); 1 );[Date]<DATE ( YEAR ( NOW () ); MONTH ( NOW () )+1; 1 )  );
        "This Month";
		IF (
        	AND ( [Date]>=DATE ( YEAR ( NOW () ); MONTH ( NOW () )+1; 1 );[Date]<DATE ( YEAR ( NOW () ); MONTH ( NOW () )+2; 1 ) );
        	"Next Month";
        	IF ( [Today] = 0; "null" )
    )
))