LobsHelper II5 years agoSolvedCalendar 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...Show MoreBA_Pete5 years agoHi Lobs , In your calendar table, create a new column and enter: startOfMonth = STARTOFMONTH(cal[date]) This should give you what you need. Pete
BA_Pete5 years agoHi Lobs , In your calendar table, create a new column and enter: startOfMonth = STARTOFMONTH(cal[date]) This should give you what you need. Pete
BA_Pete5 years agoHi Lobs , In your calendar table, create a new column and enter: startOfMonth = STARTOFMONTH(cal[date]) This should give you what you need. Pete
BA_PeteSuper User5 years agoHi Lobs , In your calendar table, create a new column and enter: startOfMonth = STARTOFMONTH(cal[date]) This should give you what you need. Pete
Related contentCalendar w/ months intervalcalendar month namesFORMAT() returns Month NumberCalendar Slicer with Different Business CalendarsLast day of Calendar month
