cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Calendar Month Format

Hi, Im trying to create my own calendar table but noticed that most of my data reports uses this format for Month "1/1/2020, 2/1/2020, 3/1/2020. Is there a way for me to capture the month of a specific date to align with the formatting some of my data sources use?

 

Lobs_0-1600701180373.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: Calendar Month Format

Hi @Lobs ,

 

In your calendar table, create a new column and enter:

startOfMonth = STARTOFMONTH(cal[date])

 

This should give you what you need.

 

Pete 

View solution in original post

3 REPLIES 3
Highlighted
Super User I
Super User I

Re: Calendar Month Format

Hi @Lobs ,

 

In your calendar table, create a new column and enter:

startOfMonth = STARTOFMONTH(cal[date])

 

This should give you what you need.

 

Pete 

View solution in original post

Highlighted
Memorable Member
Memorable Member

Re: Calendar Month Format

hi @Lobs - you should be able to format your date as "m/d/yyyy" in the data view in Power BI desktop

 

Sumanth_23_1-1600701654951.png

 

You can derive the month name and month number as seen below 

MonthName = FORMAT('Date'[Date ID], "mmmm")

Sumanth_23_2-1600701817389.png

MonthNO. = MONTH('Date'[Date ID])

Sumanth_23_3-1600701894957.png

 

OR if you want to retain your original format on the Date column, you can create a new calculated column for the required format

 

NewDateFormat = FORMAT('Date'[Date ID], "d/m/yyyy")

Sumanth_23_4-1600702013551.png

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

Highlighted
Helper I
Helper I

Re: Calendar Month Format

Thank you this worked 🙂

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors