Forum Discussion

gidon's avatar
gidon
Icon for Helper II rankHelper II
10 years ago
Solved

Create a Calander

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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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])
)
Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
gidon
Icon for Helper II rankHelper II
10 years ago

Amazing so easy one command  , just great

thanks

gidon