Month from date field (To Create a reference field)

browna6 — Mon, 27 Mar 2023 15:21:55 GMT

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 ?

Thank you

Re: Month from date field (To Create a reference field)

WinterMist — Mon, 27 Mar 2023 13:46:57 GMT

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