country based calendar filter

Hi rajasekaro 

You can either keep two separate calendar tables and use a field parameter to switch between their columns, or maintain a single table containing two sets of dates and another column to identify the country they are for. In the latter case, because the dates repeat, a many-to-many relationship with the fact tables will likely be necessary. Regardless of the approach, you will need to maintain at least two distinct sets of time intelligence calculations, especially for YTD.

 

Create a small table that defines the valid ranges per country, then filter measures using that range. Relate: Country[Country] → CountryPeriod[Country] (1:*)

CountryPeriod =
DATATABLE(
    "Country", STRING,
    "Period",  STRING,
    "StartDate", DATE,
    "EndDate",   DATE,
    {
        {"India","FY 2025-26", DATE(2025,4,1),  DATE(2026,3,31)},
        {"USA",  "CY 2026",    DATE(2026,1,1),  DATE(2026,12,31)}
    }
)

 

Then Apply the range to your measures as:

Sales =
VAR s = MIN ( CountryPeriod[StartDate] )
VAR e = MAX ( CountryPeriod[EndDate] )
RETURN
CALCULATE (
    [Sales],
    DATESBETWEEN ( 'Date'[Date], s, e )
)

If you don’t want to rewrite every measure: use a Calculation Group to wrap SELECTEDMEASURE() with the same DATESBETWEEN() logic, then set the calc item on the page filter.