Forum Discussion
Country based Calendar Silzer
rajasekaro I suggest trying to implement the new calendar feature:
Power BI’s enhanced calendar features, notably the September 2025 preview of Calendar-based Time Intelligence, allow users to define custom, non-Gregorian, and retail-specific (4-4-5, 4-5-4) calendars directly in the semantic model. This enables complex time intelligence—like week-to-date (WTD) calculations—without complex DAX, offering flexibility for fiscal, ISO, or weekly reporting.
please check this links:
https://www.youtube.com/watch?v=ILZy6pFHY5s&t=5s
https://towardsdatascience.com/use-cases-for-the-new-calendar-based-time-intelligence/#:~:text=The%20first%20prerequisite%20is%20to,data%20for%20each%20use%20case.
I hope this helps, if so please mark it as a solution. kudos are welcome.You can maintain two calendar tables and use field parameters and a slicer switch between the different date columns.
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.
I want to Control the date Slizer Based on Country selection.