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.
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.