Forum Discussion
Month from date field (To Create a reference field)
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...
WinterMist
Impactful Individual
Impactful Individual
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