[Power BI] DAX - SUMMARIZECOLUMNS

 

 

 

SUMM_TABLE 이라는 요약 테이블 만들기
TABLE에서 YEAR, PRODUCT, START, END 그룹화하고 갯수열 CNT를 추가한 테이블을 SUMMARIZECOLUMNS로 만듬
-> SUMMARIZECOLUMNS(TABLE[YEAR], TABLE[PRODUCT], TABLE[START], TABLE[END], "CNT", COUNT(TABLE[START])

해당 테이블에서 CNT가 1 이상인 행 들만 추출하고 싶음

SUMM_TABLE = SUMMARIZE(
FILTER(SUMMARIZECOLUMNS(TABLE[YEAR], TABLE[PRODUCT], TABLE[START], TABLE[END], "CNT", COUNT(TABLE[START])), [CNT] > 1),
[Year], [PRODUCT], [START], [END], [CNT]
)

 

 

 

 

SUMMARIZECOLUMNS ( 
    'Sales Territory'[Category], 'Customer' [Education], 
    FILTER('Customer', 'Customer'[First Name] = "Alicia"),
    "First", FIRSTNOBLANK('Customer'[First Name], "")
)

 

 

FIRST_DATE = SUMMARIZECOLUMNS(Report[NM],
                            FILTER(Report, Report[DATE_TIME] <= (DATE(2022,1,1) + TIME(12,0,0)) && Report[DATE_TIME] >= (DATE(2021,1,1) + TIME(12,0,0)) && Report[EVENT]<>"First"),
                            "Date", FIRSTNONBLANK(Report[DATE_TIME],""))

 

 

• D_TIME 이 2021 이전 데이터 중 마지막 D_TIME
• 열 : NM, LAST

테이블 = SUMMARIZECOLUMNS(TABLE[NM], FILTER(TABLE, YEAR(TABLE[D_TIME]) < 2021), "LAST", MAX(TABLE[D_TIME]))

 

 

docs.microsoft.com/ko-kr/dax/summarizecolumns-function-dax

SUMMARIZECOLUMNS 함수(DAX) - DAX