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] )
XaviOVHelper V3 years agoHi tamerj1 and FreemanZ The column ExecutionReference that is a unqie value of a register, if in the column DataKey cointains "HP or "GAF" in the new column (Column1) will appear "HP" or "GAF" for the same ExecutionRefence, equal that in the picture. Regards, Xavi
tamerj1Community Champion 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
