Create a Month as Excel For Forescast

Hi,

Thanks for parry2k's concern about the problem and i want to offer some more information for user to refer to.

hello clarainesgg , you can refer to the follwing solution.

Sample data

Create a calendar table.

Calendar = CALENDAR(DATE(YEAR(MIN('Table'[Date])),1,1),DATE(YEAR(MAX('Table'[Date]))+1,12,31))

Then create a measure.

MEASURE =
VAR a =
    MAXX ( ALLSELECTED ( 'Table' ), [Date] )
VAR b =
    EOMONTH ( a, 0 ) + 1
VAR c =
    EOMONTH ( a, 3 ) + 1
RETURN
    COUNTROWS ( FILTER ( 'Calendar', [Date] >= b && [Date] < c ) )

Then create a table visual and put the date of calendar table to the field and put the measure to the visual filter.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.