Forum Discussion

Lobs's avatar
Lobs
Icon for Helper II rankHelper 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 

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper 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 

  • Lobs's avatar
    Lobs
    Icon for Helper II rankHelper II
    5 years ago

    Thank you this worked 🙂