XaviOVHelper V3 years agoSolvedCreate a new column with a multipe valueHi, I have a table and I want to do it, how can I do it in DAX Now: Future: Thanks!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] )
tamerj1 to XaviOV3 years agoXaviOV please try Column1 =MAXX ( FILTER ( CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ), 'Table'[DataKey] IN { "HP", "GAF" }), 'Table'[DataKey] )
6 RepliesReplies sorted by Most Likedtamerj1Community Champion3 years agoHi XaviOV based on what?XaviOVHelper V to tamerj13 years agoHi tamerj1 , Based on ExecutionReference Regards, Xavitamerj1Community Champion to XaviOV3 years agoXaviOV I mean why "GAF" not "Caudal" for example? Based on what? Or you have a list of the Key values that need to be kept?Show MoreShow More
tamerj1Community Champion to XaviOV3 years agoXaviOV I mean why "GAF" not "Caudal" for example? Based on what? Or you have a list of the Key values that need to be kept?
Related contentCreate columns groupCreating a date columnCreating a custom columnunpivoting columns and creating datetime columnAppending columns and creating new column of old column headers
