Business Intelligence

Power BI Time Intelligence Giving Wrong Results with Non-Standard Calendars

Power BI's built-in time intelligence functions assume a standard Gregorian calendar. When your data uses fiscal years, 4-4-5 periods, or custom date tables, those functions silently return wrong numbers. Here's how to diagnose and fix it.

Jul 04, 2026 9m read 👁 2

Power BI Cumulative Totals Resetting Unexpectedly: DAX Fixes That Actually Work

Your Power BI running total looks perfect on the first page, then resets to zero on the next date or category. Here's why DAX cumulative measures break and exactly how to fix them.

Jul 04, 2026 8m read 👁 3