Calendar Month Format

[Lobs]

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?

[Sumanth_23]

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

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

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

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

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")

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

[BA_Pete · Accepted solution]

Hi @Lobs ,

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

startOfMonth = STARTOFMONTH(cal[date])

This should give you what you need.

Pete 

[Lobs]

Thank you this worked 🙂