본문 바로가기
SSAS (Tabular)

DAX Query

MANY to MANY

 

HASONEFILTER & SWITCH

 

Filter

 

Sum

 

Count

 

Min

 

Max

 

DistinctCount The aggregation is a count of unique members

 

None No aggregation is applied

 

ByAccount The system reads the semiadditive behavior specified for the account type

 

AverageOfChildren The aggregation of a member is the average of its children

 

FirstChild The member value is evaluated as the value of its first child along the time dimension

 

LastChild The member value is evaluated as the value of its last child along the time dimension

 

FirstNonEmpty The member value is evaluated as the value of its first child along the time dimension that contains data (현재 컨텍스트를 기준으로 필터링한 column 열에서 식이 비어 있지 않은 마지막 값을 반환합니다)

 

LastNonEmpty The member value is evaluated as the value of its last child along the time dimension that contains data

 

PARALLELPELIOD PARALLELPERIOD([Time].[CM Time].[Week],52,[Time].[CM Time].CurrentMember)

 

Avg Avg(PARALLELPERIOD([Time].[CM Time].[Week],3,[Time].[CM Time].CurrentMember):[Time].[CM Time].CurrentMember, [Measures])

 

Calculate

 

Index Column