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
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.
maintainer
ECNU-ICALK
์
๋ฐ์ดํธ๋จ 2026. 3. 13.
์คํ
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