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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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