Use the below Code.
New Table ->
Calender =
ADDCOLUMNS (
CALENDAR ("01-Jan-2013", "31-Dec-2030"),
"DATE_WID", FORMAT([Date],"YYYYMMDD"),
"Creation Date", FORMAT([Date],"DD-MMM-YYYY"),
"Year", FORMAT([Date],"YYYY"),
"Month", FORMAT([Date],"M"),
"MonthName",FORMAT([Date],"MMM"),
"Quarter", "Q" & FORMAT ( [Date], "Q" ))
No comments:
Post a Comment