Forum Discussion
how to get split column values based on the another table conditions
I having two table both sheet gave a common value Market code 1.mergedsheet 2.Monthly rep Merged sheet have values filed actauls mergedsheet KEY MARKETCODE ...
Anonymous You could use a Merge query in Power Query to do this probably. For DAX columns, try:
DS Column = VAR __Key = [KEY] VAR __Market = [MARKETCODE] VAR __DSNDS = MAXX(FILTER('Monthly rep',[KEY]=__Key && [MARKETCODE]=__Market),[DS/NONDS]) RETURN IF(__DSNDS = "DS",[ACTAULS],0)
Greg_Deckler
Community Champion
Community ChampionAnonymous You could use a Merge query in Power Query to do this probably. For DAX columns, try:
DS Column =
VAR __Key = [KEY]
VAR __Market = [MARKETCODE]
VAR __DSNDS = MAXX(FILTER('Monthly rep',[KEY]=__Key && [MARKETCODE]=__Market),[DS/NONDS])
RETURN
IF(__DSNDS = "DS",[ACTAULS],0)Greg_Deckler tired this measure but i am getting error DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
- Greg_Deckler
Anonymous As an experiment,replace your RETURN with just 1 and see if the error goes away. Seems like everything being compared should be text.