Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
browna6
Frequent Visitor

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 the month number and year from the data column - which will allow me to create a reference of Year * 12 + month number

 

Any Suggestions ?

 

customerdue-dateMonth NumberYearReferenceCalculation
100128/02/20232202324278=(D2*12)+C2
100131/03/20233202324279 
100131/03/20223202224267 
100130/04/20224202224268 
100130/06/20226202224270 
100131/08/20228202224272 

 

Thank you 

 

power bi image.JPG

 

1 REPLY 1
WinterMist
Impactful Individual
Impactful Individual

@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

 

WinterMist_0-1679924772549.png

 

Hope this is helpful to you.

 

Regards,

Nathan

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.