Looking to find a way to have the calendar table go from 10/2016 through the end of the previous month using the Dax below. Based on today, the calendar table would be (10/2016 - 03/2021). Thanks for any help.
DimDate =
var FY ="10"
VAR k =
CALENDAR ( DATE ( 2016, 10, 01 ), today())
RETURN
FILTER ( k, DAY ( [Date] ) = 1 )
DimDate =
var FY ="10"
VAR k =
CALENDAR ( DATE ( 2016, 10, 01 ), today())
RETURN
FILTER ( k, DAY ( [Date] ) = 1 )
