How to get Calender table with Month start Date

[Balaraju]

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[Month Start Date]))

I have data from 01-Jan- 2021 to 28-Feb 2022 the table showing records 01-Jan 2021 to 01-Feb-2022 because of month start date I need calender table like 01-Jan- 2021 to 28-Feb 2022. Could you please help me on that. 

Note: The data is not end at Feb it will refresh every month the months will add but maximum date shoul be end of the Month.

[Tahreem24 · Accepted solution]

@Balaraju, Try this Date Table:

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

[mh2587]

https://powerbi.tips/2017/12/start-of-month-dax-calendar/

[Balaraju]

Hi @mh2587 Actually the data is not end with Feb it will refresh every month and next month will add.