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.From its SKILL.md
npx -y skills add ECNU-ICALK/AutoSkill --skill dax-date-intersection-count-with-rankxAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
SKILL.md
2.0 KB, 304 tokens by cl100k_base, as published. Nobody here has run it
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
- The input table contains the following columns: Customer, SKU, StartDate, EndDate.
- Partition the data by the Customer and SKU columns.
- Order the data by the StartDate column.
- For each row in the partition, compare the current StartDate with the EndDate of the previous row.
- Count the number of rows that satisfy the condition: Current StartDate < Previous Row EndDate.
- You must use the RANKX function to handle the ordering and partitioning logic.
- 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
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.