skills.homes logoskills.homescapability registry
home/categories/data-engineering/ecnu-icalk-autoskill-skillbank-convskill-english-gpt3-5-8-glm4-7-dax-date-intersection-count-with-rankx-skill-md
cd ..
data-engineeringdata-ai

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.

View Sourcedata-engineering
ECNU-ICALK
maintainer
ECNU-ICALK
Updated 3/13/2026
Stars
304
Forks
34
quick start

Installation and usage

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.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use dax-date-intersection-count-with-rankx