Forum Discussion
Matt_Mohawk
Helper II
Helper IICount Jobs within Dates Selected
Hi, I have a list of jobs that have entered dates. I have a date table connected to it as well. The date table is connected to the add-in called ChicletSlicer. When I select the year and the mont...
Matt_MohawkHelper II
Helper III appreciate the formula that you provided but for some reason it doesn't work correctly. Can you include what my calendar formula should look like? This is what it looks like on my side.
Date =
ADDCOLUMNS (
CALENDAR (DATE(2017,1,1), DATE(2032,12,31)),
"DateAsInteger", FORMAT ( [Date], "MMDDYY" ),
"Year",YEAR([Date]),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)
Ashish_Mathur
Super User
Super UserHi,
Create the Calendar table with the following formula
Calendar = calendar(DATE(2017,1,1), DATE(2032,12,31))
Write these calculated column formulas
Year = year(Calendar[Date])
Month name = format(calendar[Date],"mmmm")
Month number = month(calendar[Date])
Sort the Month name column by the Month number. to your visual, drag Year and Month name from the Calendar Table.
Hope this helps.