Counts With rolling Months

Hi rakeshsaini

On your DATE table, make sure you have the following calculated columns.

MonthID = INT(format('Dates'[Date],"YYYYMM"))

&

Month = FORMAT('Dates'[Date],"MMM-YY")

Once you have these two columns on your DATE table, make sure the Month column is sorted by MonthID, and use the Month column from your DATE table on the axis of your visual.  

Thanksl Phil_Seamark . Its Working !! but Its Showing All Months From JAN-15 to DEC-17 , We Need to Map Months With Current Month on X-Axis (FEB-16 to FEB-17).

Now , its Showing ..

Try adding this column to your Date table

Months from Today = IFERROR( DATEDIFF('Dates'[Date],TODAY(),MONTH),-1)

Then you can add it as a Report, Page or Visual level filter to only show values between 0 and 12 (or 1 and 12).  This will dynamically roll as we go into new months

The new column looks good.

Simply drag the new column into your "Report level filters" box and configure as below (and hit apply)