Create a Calander

Question

Hii have a date tablelook like this&nbsp; i want to creat a table that will be my calander , start date will be the lowst date , end date will be the highst datein 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 ,thanksgidon&nbsp;&nbsp;&nbsp;FactpartcustQuantUnitPCURIVInvoice1001100050010/10/151Invoice2003550060011/11/142Invoice3006700070012/12/153Invoice20071500080003/15/134Invoice1008900040003/12/115Invoice2009900030003/12/096Invoice3001900020003/12/077Invoice4003900025008/15/128Invoice1006900050007/07/179

anonymous · Accepted Answer

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:&nbsp; CalendarTable = CALENDAR(
	MIN(Tablename[CUR]),
	MAX(TableName[CUR])
)

Forum Discussion

Create a Calander

2 Replies

Related content

Creating relationships

Creating ICMs via Activator

Network Days calculation with Calander and holidays

Data Days | Create

Create new table

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