Forum Discussion

Balaraju's avatar
Balaraju
Icon for Helper III rankHelper III
4 years ago
Solved

How to get Calender table with Month start Date

Hi All,   I have fact table with Month start date, I am creating calender table based on month start date using below formula. Dim_calendar= CALENDAR(MIN(Table[Month Start Date]), MAX(Table[Mont...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Balaraju, Try this Date Table:

    MyDate Table = CALENDAR(MIN(DateTable[Date]),EOMONTH(MAX(DateTable[Date]),0))
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Balaraju, Try this Date Table:

MyDate Table = CALENDAR(MIN(DateTable[Date]),EOMONTH(MAX(DateTable[Date]),0))