home/categories/data-engineering/ecnu-icalk-autoskill-skillbank-convskill-english-gpt3-5-8-glm4-7-dax-date-intersection-count-with-rankx-skill-md

data-engineeringdata-ai

dax-date-intersection-count-with-rankx

Name: dax-date-intersection-count-with-rankx
Author: ECNU-ICALK

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.

عرض المصدر data-engineering

maintainer

ECNU-ICALK

آخر تحديث 3/13/2026

النجوم

304

التفرعات

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.

التثبيت

$ install --globalskills.sh

الاستخدام

بعد التثبيت، يمكنك استخدام هذه المهارة بتشغيل الأمر التالي في الطرفية:

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