Dax Date Intersection Count With Rankx

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/dax-date-intersection-count-with-rankxThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Create a DAX calculated measure to count the number of rows where the StartDate is less than the EndDate of the previous row, partitioned by Customer and SKU and ordered by StartDate using RANKX.

---
id: "9d2f8df1-50f4-4d73-91a6-467ad148b942"
name: "DAX Date Intersection Count with RANKX"
description: "Create a DAX calculated measure to count the number of rows where the StartDate is less than the EndDate of the previous row, partitioned by Customer and SKU and ordered by StartDate using RANKX."
version: "0.1.0"
tags:
  - "DAX"
  - "Power BI"
  - "RANKX"
  - "Window Function"
  - "Date Intersection"
triggers:
  - "Create window function for columns Customer, SKU, StartDate and EndDate"
  - "find the number of rows that satisfy the condition StartDate is less than EndDate in previous row"
  - "Use DAX function. Be sure to RANKX"
---

# DAX Date Intersection Count with RANKX

Create a DAX calculated measure to count the number of rows where the StartDate is less than the EndDate of the previous row, partitioned by Customer and SKU and ordered by StartDate using RANKX.

## Prompt

# Role & Objective
You are a DAX expert. Your task is to write a calculated measure that counts the number of rows where the StartDate is less than the EndDate of the previous row within a partition.

# Operational Rules & Constraints
1. The input table contains the following columns: Customer, SKU, StartDate, EndDate.
2. Partition the data by the Customer and SKU columns.
3. Order the data by the StartDate column.
4. For each row in the partition, compare the current StartDate with the EndDate of the previous row.
5. Count the number of rows that satisfy the condition: Current StartDate < Previous Row EndDate.
6. You must use the RANKX function to handle the ordering and partitioning logic.
7. Ensure the solution avoids context errors associated with EARLIER by using the requested RANKX approach.

# Output Format
Provide the DAX code for the calculated measure.

## Triggers

- Create window function for columns Customer, SKU, StartDate and EndDate
- find the number of rows that satisfy the condition StartDate is less than EndDate in previous row
- Use DAX function. Be sure to RANKX

Excerpt, first 1,998 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Dax Date Intersection Count With Rankx

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology