Reported Date =
ADDCOLUMNS (
CALENDAR (MIN(Tickets[Reported Date]),MAX(Tickets[Reported Date])),
"Reported Date DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Reported Date Year", YEAR ( [Date] ),
"Reported Date Monthnumber", FORMAT ( [Date], "MM" ),
"Reported Date Year-Month", FORMAT ( [Date], "YYYY-MM" ),
"Reported Date YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"Reported Date MonthNameShort", FORMAT ( [Date], "mmm" ),
"Reported Date MonthNameLong", FORMAT ( [Date], "mmmm" ),
"Reported Date DayOfWeekNumber", WEEKDAY ( [Date] ),
"Reported Date DayOfWeek", FORMAT ( [Date], "dddd" ),
"Reported Date DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Reported Date Quarter", "Q" & FORMAT ( [Date], "Q" ),
"Reported Date Year-Quarter", FORMAT ( [Date], "YYYY" ) & "-Q" & FORMAT ( [Date], "Q" )
)
ADDCOLUMNS (
CALENDAR (MIN(Tickets[Reported Date]),MAX(Tickets[Reported Date])),
"Reported Date DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Reported Date Year", YEAR ( [Date] ),
"Reported Date Monthnumber", FORMAT ( [Date], "MM" ),
"Reported Date Year-Month", FORMAT ( [Date], "YYYY-MM" ),
"Reported Date YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"Reported Date MonthNameShort", FORMAT ( [Date], "mmm" ),
"Reported Date MonthNameLong", FORMAT ( [Date], "mmmm" ),
"Reported Date DayOfWeekNumber", WEEKDAY ( [Date] ),
"Reported Date DayOfWeek", FORMAT ( [Date], "dddd" ),
"Reported Date DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Reported Date Quarter", "Q" & FORMAT ( [Date], "Q" ),
"Reported Date Year-Quarter", FORMAT ( [Date], "YYYY" ) & "-Q" & FORMAT ( [Date], "Q" )
)
No comments:
Post a Comment