XaviOVHelper V3 years agoSolvedCreate a new column with a multipe value Hi, I have a table and I want to do it, how can I do it in DAX Now: Future: Thanks! Show Moretamerj1 to XaviOV3 years agoXaviOV please try Column1 =MAXX ( FILTER ( CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ), 'Table'[DataKey] IN { "HP", "GAF" }), 'Table'[DataKey] )
tamerj1 to XaviOV3 years agoXaviOV please try Column1 =MAXX ( FILTER ( CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ), 'Table'[DataKey] IN { "HP", "GAF" }), 'Table'[DataKey] )
tamerj1 to XaviOV3 years agoXaviOV please try Column1 =MAXX ( FILTER ( CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ), 'Table'[DataKey] IN { "HP", "GAF" }), 'Table'[DataKey] )
Related contentCreate columns groupCreating a date columnCreating a custom columnunpivoting columns and creating datetime columnAppending columns and creating new column of old column headers
