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.

檢視原始碼data-engineering
ECNU-ICALK
maintainer
ECNU-ICALK
更新於 3/13/2026
星標
304
分支
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.

安裝
$ install --globalskills.sh
使用

安裝後，您可以透過在終端機執行以下指令來使用此技能：

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