Date Filter for First Date of Month

Questions & Answers
1

Can I create a date filter of first dates of all months?

2

Hello @jabrillo

Yes, this can be done by defining a new calculated member in Time dimension using the formula below.

Aggregate(
  Filter(
    [Time].[Day].Members,
    [Time].CurrentMember.get('Month day') = 1
  )
)

Best wishes,

Elita from support@eazybi.com