Visual not displaying data when using month as X-axis

[Sohan]

I have the following DAX measure: 

Rolling AVG NPs = 

var periodCalculation = -3

var result =
CALCULATE([A],
          DATESINPERIOD(DimCalendar[Date],
                        LASTDATE(DimCalendar[Date]), periodCalculation, Month
                       )
         )

var finalResult = 
result /
CALCULATE(DISTINCTCOUNT(DimCalendar[Year/Month]),
          DATESINPERIOD(DimCalendar[Date],
                        LASTDATE(DimCalendar[Date]), periodCalculation, Month
                       )
         )

RETURN finalResult

When I visualize this measure with DimCalendar[Year/Month], the data is displayed. When I visualize it with DimCalendar[Month], the visual is empty. Does anyone know how I can fix this?

[amitchandak · Accepted solution]

@Sohan , if you do not have a slicer/filter on the page. the last date will take a month to the last available month in date table, which might not have data.

Seem like very similar to

Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg