Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dax for creating date column for specific dates.

Hello, Please anyone can tell me how can i create the dax column for date table as it will automatically add 1st date of every month  like eg:- Year & Month Identifier = {"01-January-2018","01-Fe...
CALENDER
Date
DAX
Anonymous's avatar
Anonymous
Not applicable
4 years ago

STARTOFMONTH(Tablename(datescolumn).[date])

 

This function will give first date of each month in new column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    No i want to create the table by not taking any value this the main date table no other date table is there.