limit the date table to not show beyond a certain date which is dynamic

[Nischal]

date table should not show dates which are beyond the last date which is present in the date column of the other table..... 

[Ashish_Mathur · Accepted solution]

Hi,

Try this

=CALENDAR(MIN(Data[Dates]),MAX(Data[Dates]))

[Seth_C_Bauer]

@Nischal I don't know how you are currently building your date table, but if you do it by building a dax table using the value of the data table. My reference looks like this:

Date =
ADDCOLUMNS (
CALENDAR (MINX('DataTable', [DateValue]), (MAXX('DataTable',[DateValue]))),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"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" )
)