Create a Calander

[gidon]

Hi

i have a date table

look like this  i want to creat a table that will be my calander , start date will be the lowst date , end date will be the highst date

in the table , the date colmun name is CUR , i want to have all date in my calader , even if they do not show the data table ,

thanks

gidon

Fact	part	cust	Quant	UnitP	CUR	IV
Invoice	100	1	1000	500	10/10/15	1
Invoice	200	3	5500	600	11/11/14	2
Invoice	300	6	7000	700	12/12/15	3
Invoice	200	7	15000	800	03/15/13	4
Invoice	100	8	9000	400	03/12/11	5
Invoice	200	9	9000	300	03/12/09	6
Invoice	300	1	9000	200	03/12/07	7
Invoice	400	3	9000	250	08/15/12	8
Invoice	100	6	9000	500	07/07/17	9

[Anonymous · Accepted solution]

Hit the New Table button. I don't know what the sample table you showed is named so I'm just going to call it TableName. Enter this formula, adapted with the correct name for your table:

 CalendarTable = CALENDAR(
	MIN(Tablename[CUR]),
	MAX(TableName[CUR])
)

[gidon]

Amazing so easy one command  , just great

thanks

gidon