topic Re: New column based on another two columns in DAX Commands and Tips

New column based on another two columns

ROG — Thu, 16 Jun 2022 14:48:28 GMT

Hi all,

I'm trying to create a new column based on the two columns below highlighted in pink.
The new column should say Yes if these two columns have "Yes" and No if one of them is "No".
I tried the the dax below, but it won' work.

Thank you

Re: New column based on another two columns

Greg_Deckler — Thu, 16 Jun 2022 15:02:51 GMT

ROG Try:

RETURN IF(Flag8Wk_CNSize = 1 && _8WkSigTest = 1, "Yes", "No")

Re: New column based on another two columns

tamerj1 — Thu, 16 Jun 2022 15:03:21 GMT

Hi ROG

after RETURN change the && to + and change the 1 to 2

Re: New column based on another two columns

ROG — Fri, 17 Jun 2022 08:04:33 GMT

Thanks for your reply Greg_Deckler
It's not working because o the data type.
The two measures I used to create the new column a type= text, but the new one I changed from number to general. There isn't an option to change to text for this measure. What woul you do in this case?

Re: New column based on another two columns

Greg_Deckler — Fri, 17 Jun 2022 12:46:23 GMT

ROG It would appear that one or both of the columns/measures that you have highlighted are returning numbers and not text. So, you need to address those comparisons. Are they really returning "Yes" and "No"? Doesn't seem like it.

Re: New column based on another two columns

tamerj1 — Fri, 17 Jun 2022 12:55:11 GMT

Hi Greg_Deckler
The issue is that ROG is trying to compare a measure of type percentage ( [8 WK Diff %] ) with a text ("Yes"). Better if he advises what is he trying to achieve.

Re: New column based on another two columns

ROG — Fri, 17 Jun 2022 13:34:32 GMT

Thanks a million tamerj1
I was indeed using a wrong measure. The below worked.

8WK CN Size_SigTest =

VAR _8WkSigTest = IF([CHI_SQUARE_TAKERS_8_WK_ACTIVE] = "Yes", 1, 0)

VAR Flag8Wk_CNSize = IF([flag_8_wk] = "Yes",1, 0)

Return IF( _8WkSigTest = 1 && Flag8Wk_CNSize = 1, "Yes", "No")