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.

Voir le code sourcedata-engineering
ECNU-ICALK
maintainer
ECNU-ICALK
Mis à jour 3/13/2026
Étoiles
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
Utilisation

Après l'installation, vous pouvez utiliser ce skill en exécutant la commande suivante dans votre terminal :

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