Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago
Solved

month start date

I have dates from 02 aug 2018 to 30 aug 2018 ...    when i create  this column in table using this    Start_Monthdate = STARTOFMONTH(TBL_Endo_Start_Date[Date])   i got 02 aug 2018 .. where as ...
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    Bakhtawar 

    The start of month will not go beyond the date boundaries of the table. That might be the date you have in the table

     

    Start of Month = Date(Year(TBL_Endo_Start_Date[Date]),month(TBL_Endo_Start_Date[Date]),1)

amitchandak's avatar
amitchandak
Super User
6 years ago

Bakhtawar 

The start of month will not go beyond the date boundaries of the table. That might be the date you have in the table

 

Start of Month = Date(Year(TBL_Endo_Start_Date[Date]),month(TBL_Endo_Start_Date[Date]),1)