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.

Ver código-fontedata-engineering
ECNU-ICALK
maintainer
ECNU-ICALK
Atualizado 3/13/2026
Estrelas
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.

Instalação
$ install --globalskills.sh
Uso

Depois de instalar, você pode usar esta skill executando o seguinte comando no terminal:

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