Create an Auto Calerndar Table with End of Month

[lcasey]

Hello,

Is there any way to create a calendar table in Power BI that would create a table for Just end of month dates so I could relate that table to budget and transaction tables?

I have two tables:

GLSummary-  which contains actual Dates of the transactions

Budget - Which only contains Year and Period

I want to create an automatic date table that would do this:

Calendar = Claendar(EOM(MIN(GLSummaryDate), EOM(MAX(GLSummaryDate)

I know the above formula is not correct and thats what I need help with. I ultimately want a Date table that looks like this from the Minimum and Maximium Dates in the GLSummary table

[lcasey]

This does NOT work in Power BI. I think the DAX engine is broken

EVALUATE
FILTER (
    CALENDAR ( MIN ( '00-GLSummary'[TRXDATE] ), MAX ( '00-GLSummary'[TRXDATE] ) ),
    [Date] = EOMONTH ( [Date], 0 )
)

[lcasey · Accepted solution]

aaah ok

this worked: 

Calendar = FILTER (
    CALENDAR ( MIN ( '00-GLSummary'[TRXDATE] ), MAX ( '00-GLSummary'[TRXDATE] ) ),
    [Date] = EOMONTH ( [Date], 0 )
)

[moatazezat]

excellent

[achinchilla]

Genious!!!

[v-huizhn-msft]

Hi @lcasey,

I am very glad to hear you have resolved your issue, please mark the right reply as answer. So other people will find the solution easily.

Best Regards,
Angelia