Track changes within 3 columns

[iczkla]

Hello,

I have a table in which there are  columns ID, Compensation Change, Job Title Change and Location Change.

In each column value is either yes or no, so it looks something like that:

ID | Compensation Change | Job Title Change | Location Change

1   | Yes                                         | Yes                              | No

2   | No                                          | No                               | No

3   | Yes                                         | Yes                              | Yes

I want to track changes not separately but together - so irregardless if ID had 1 or 3 changes this should be treated as 1, so result should look something like this:

ID | Compensation Change | Job Title Change | Location Change | CHANGE?

1   | Yes                                         | Yes                              | No                             | Yes

2   | No                                          | No                               | No                             | No

3   | Yes                                         | Yes                              | Yes                            | Yes

I am assuming that I need to include some set analysis into my script but I am not sure how to do this.

Any help would be much appreciated. Thank you!

[Taoufiq_Zarra]

@iczkla  can you elaborate ?

how you get Yes for exemple in change for the first row and the second ?

[iczkla]

Hi Taoufiq,

This is just how my data looks like - my goal is to create 5th column which will  show if there was a change in the row, regardless of the number of changes. So if 1 or more changes result will be Yes, and if 0 changes result will be No.

[Taoufiq_Zarra]

yes, but why Yes for ID 3 and Yes for the TD 1 ?

ID | Compensation Change | Job Title Change | Location Change | CHANGE?

1 | Yes | Yes | No | Yes

2 | No | No | No | No

3 | Yes | Yes | Yes | Yes

[iczkla]

If there's at least one change in a row then Change column show Yes value, in ID 1 we have 2 Yes', condition =>1 Yes has been met, and in ID3 we have 3 Yes' so condition =>1 Yes has beet met as well.

I am sorry I am not able to explain more my logic ;<

[Taoufiq_Zarra · Accepted solution]

@iczkla  Maye be like :

in dimension : ID | Compensation Change | Job Title Change | Location Change 

measure:

=if(wildmatch([Compensation Change]&[Job Title Change]&[Location Change],'*YES*')>0,'YES','NO')

output:

[iczkla]

It works!!! Thank you so much for the help!