Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

dax calendar eomonth min/max

hi all,   am trying to create a table with all dates of a year and did it like this: yrCalendar= CALENDAR(EOMONTH(MIN('Treg'[ActivityDate]),-1)+1,EOMONTH(MAX('Treg'[ActivityDate]),0)) but i get an...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    Try this formula please.

    dCalendar02 =
CALENDAR (
    EOMONTH ( MIN ( 'Time registration'[ActivityDate] ); -1 ) + 1;
    EOMONTH ( MAX ( 'Time registration'[ActivityDate] ); 0 )
)

    Best Regards!

    Dale

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous works find for me are you creating a new table?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

yes, want to create a new table.....