PBI Workshop


Class Materials -> 02-01


Class Materials -> 04-14


Dates = 
ADDCOLUMNS(
    CALENDAR(MIN('AR Invoice Lines'[Date]),MAX('AR Invoice Lines'[Date])),
    "Year",YEAR([Date]),
    "Month Number",MONTH([Date]),
    "Month",FORMAT([Date],"MMMM"),
    "MMM-YYYY",FORMAT([Date],"MMM-YYYY"),
    "Day Of Week Number",WEEKDAY([Date]),
    "Day Of Week",FORMAT([Date],"DDDD"),
    "YYYY-MM",FORMAT([Date],"YYYY-MM"),
    "My Month",FORMAT([Date],"MMM YY"),
    "Week Ending",[Date]+7-WEEKDAY([Date],1)
)