Forum Discussion

gidon's avatar
gidon
Helper II
9 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
    9 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
9 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
    Helper II
    9 years ago

    Amazing so easy one command  , just great

    thanks

    gidon