Forum Discussion

Lobs's avatar
Lobs
Helper II
5 years ago
Solved

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 specif...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi Lobs ,

     

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

    startOfMonth = STARTOFMONTH(cal[date])

     

    This should give you what you need.

     

    Pete 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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!