Month from date field (To Create a reference field)

[browna6]

Hi

I am looking to get the month number and the year when referening a date field 

However, when trying to use Month() or Format () it doesnt allow me to use the Date field 

I want to get the month number and year from the data column - which will allow me to create a reference of Year * 12 + month number

Any Suggestions ?

customer	due-date	Month Number	Year	Reference	Calculation
1001	28/02/2023	2	2023	24278	=(D2*12)+C2
1001	31/03/2023	3	2023	24279
1001	31/03/2022	3	2022	24267
1001	30/04/2022	4	2022	24268
1001	30/06/2022	6	2022	24270
1001	31/08/2022	8	2022	24272

Thank you 

[WinterMist]

@browna6 

I regularly use the following DAX from SQLBI to create a Date Table.  Highlighted in the code are the 2 items you are looking for:

- Year

- Month Number

Hope this is helpful to you.

Regards,

Nathan