Forum Discussion
calendar cannot be blank
i use measure not colomn in calendar arguments
waleed111 , can you share what is there in the list view table
i use measure not colomn therefore max and min not work with measure may be
 
waleed111
Go to Modeling Tab click on New Table and paste this code, Your measures Start Date and End Date will be accepted.
Please show how those measures are calculated.Date = CALENDAR('List View'[start date],'List View'[end date])
I did an experiment creating a calendar table with Measures________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Measures are accepted as values in tables, however since measure are based on context, the result is not dinamic, so if you have two measures with MIN(Table[Date]) and MAX(Table[DAte]) this values will always pick up the maximum and minimum value of the table that you refer to, they are no dinamic.
To my experience ussualy when people use measure in table it's because they want the dinamic part of the measure so when they select the slicer or change a parameter or something like that the table is dinamic, and that doesn't happen because as you know measures a context base so when you pick up a measure it get the table context and not the row context so the values are always the same and don't change no matter what you do with the other context settings like slicers, filters, or similar.
That's the reason why I refered that measures cannot be used, better said measures should not be used in a table creation.
But great answer.
Hi amitchandak ,
Measure cannot be used to create new tables or columns.
Don't know what is the syntax of your measure, but if you it's a MIN(Table[Date]) the values used on the table should be the same one and not refering to the measure, if however this is a dinamic measure that is depending on slicer or similar, as refered it cannot be used to create a new table.
waleed111 , If I have a list table I can calendar using the column that table has
Calendar(min(List View[Start date]), Max(List View[End Date]))
Check the Attached Pbix , How I done with My tables
