Forum Discussion

rakeshsaini's avatar
rakeshsaini
Icon for Helper II rankHelper II
9 years ago
Solved

Counts With rolling Months

Hello Everyone ,   I Want to Create A Report to Show My Table Record Counts with  rolling Months .I Have a CreatedDate Column in My Table . How can I Create this Visualization  with Rolling Months...
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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.  

 

 

rakeshsaini's avatar
rakeshsaini
Icon for Helper II rankHelper II
9 years ago

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 ..