Compare different columns to get new measure

[MK9885]

hi,

I'm trying to compare columns and create a new column

Would like to compare all these columns with different values to create a new column...

New Column should only contain values which are not Adj from Column4 & are only Com2 from Column3.

So here New Column values would only be measure with a combination of XYZ+555+Com2 and ABC+555+Com2 

Other scenario can be below

Here the new Column values would be measure with combination of ABC+555+Com2 beacause XYZ has Adj in Column4

@sunny_talwar 

Thanks.

[Arthur_Fong]

Try this:

Refer the expressions from the QVW attached.

Thanks and regards,

Arthur Fong 

[MK9885]

Sorry that was an example which clearly I did not explain good enough..

[Arthur_Fong]

Hi Khan,

Refer qvw attached for the logic that i have done.

Thanks and regards,

Arthur Fong 

[MK9885]

Thanks a lot!

I'll try it on my app & let you know

[MK9885]

Flag you've created is giving value as 0 instead of 0 or 1 or 2.

[Arthur_Fong]

Can you try to aggregate your temp table by:

Carrier Name,

Procedure Code,

Adjustment

Also do a filter for Carrier Name= 'Champus' on the temp table.

[MK9885]

Ok, I'm doing some adjustments as requested will update you...

Thanks for all your help, really appreciate it 

[Brett_Bleess]

Khan, did Arthur's example end up working out for you?  If so, do not forget to circle back and mark his post using the Accept as Solution button to give him credit and to let others know what actually worked.

Regards,
Brett

[MK9885]

No, this is still an open issue.