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 specific date to align with the formatting some of my data sources use?

 

 

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 

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    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!