Forum Discussion
Helper Vcalendar cannot be blank
Super User
Helper Vi use measure not colomn therefore max and min not work with measure may be
 
- Fowmy
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 🙂
- MFelix
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.
- Fowmy
I absolutely agree on your points and am fully aware of it as well.
I am not sure about waleed111 purpose here, very little information provided to cater a solution.
if he is creating a standard calendar, it's not the proper way either.
________________________
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 🙂
- MFelix
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.
- amitchandak
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
