All checks
DAXDAX QualityMedium

"Previous period" window overlaps the current one

""Previous period" window overlaps the current one" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) compare two DATESINPERIOD windows anchored on the same date with different lengths (for example -3 and -6 months). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Anchor the previous window on EDATE(anchor, -N) with the same length, or use DATEADD on the current window.

What is detected

n measure(s) compare two DATESINPERIOD windows anchored on the same date with different lengths (for example -3 and -6 months). The longer window contains the shorter one, so the comparison is current-vs-(current+previous), not current-vs-previous.

Why it matters

Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.

How to fix it

Anchor the previous window on EDATE(anchor, -N) with the same length, or use DATEADD on the current window.

Does your model fail this check?

Free static audit with the exact objects, no account, nothing stored.

Audit a model

More DAX checks