Day Range wise monthly data required

How do I get the monthly data for 2 date ranges as 01 to 15 of every month and 16 to 30 of every month?

Row - EPIC & Issues
Columns - Col1( Month date range 1-15) & Col2 (Month date range 16-30)

Hi @Jayant_Ghorpade,
You can create a measure that would get the date part of the issue property. For example, I am using “Issue created date”, this is only to test that this expression returns correct dates:

cast(
  ExtractString(
    Cast([Measures].[Issue created date] as String),
    "(\d+)",1
  ) as NUMERIC
)

Then based on this measure, you can create two measures. One to count issues that are created till 15th date:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues created]>0 
    AND
    cast(
      ExtractString(
        Cast([Measures].[Issue created date] as String),
        "(\d+)",1
      ) as NUMERIC
    )<=15
  ),
  1
)

and the second to count issues that are created after the 15th day.

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues created]>0 
    AND
    cast(
      ExtractString(
        Cast([Measures].[Issue created date] as String),
        "(\d+)",1
      ) as NUMERIC
    )>15
  ),
  1
)

In the report then, you can get two columns:

best,
Gerda // support@eazyBI.com