Hi,
I built a two column table using 'enter data' , two columns two dates, I then used add columns to add a column
YEAR('EnterData'[Enddate])
to get year,
But when I tried to use these dates to build a calendar I had to wrap in Min or Max, there was only one so didn't matter,
CalendarA =
VAR startd = DATE( YEAR( MIN('EnterData'[Sdate]) ),1,1)
VAR endd = MAX('EnterData'[Enddate])
VAR dateC = CALENDAR(startd, endd )
RETURN
ADDCOLUMNS(
dateC,
"Year", YEAR([Date] )
My question regards why in the fist example , add column, I could use YEAR directly but in the second I had to use the MIN first,
I don't really know what question I need to be asking in order to find the answer, if anyone has an answer or directions to a post on this
I'd be grateful.
RD
Bookmarks