Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
THENNA_41
Post Partisan
Post Partisan

compare two columns

I have Global POL table, trying to Compare the two column  CBL and CBL LOCAL  .If both column value same its return  true. if values not match and both column blank its return False. i have tired the below measure . 

 

True/False =
IF (
    'Global POL'[CBL]= 'Global POL'[CBL Local],
    "True",
   "False"
   
)

 

INPUT :

 

   ID                  CBL                                                  CBL LOCAL 

  122         MS14-CA04CAS002                     MS14-CA04CAS002

  123        MS14-CA04CAS004                     MS14-CA04CAS004 

  124        MS14-CA04CAS004                     MS14-CA04CAS002 

  125

 

EXPECTED OUTPUT:

 

   ID                  CBL                                                  CBL LOCAL                         TRUE/FALSE

  122         MS14-CA04CAS002                     MS14-CA04CAS002                          TRUE 

  123        MS14-CA04CAS004                     MS14-CA04CAS004                           TRUE 

  124        MS14-CA04CAS004                     MS14-CA04CAS002                           FALSE

  125                                                                                                                        FALSE

5 REPLIES 5
KeyurPatel14
Responsive Resident
Responsive Resident

Hii @THENNA_41 ,
Please enter below formula:

KeyurPatel14_0-1674022700451.png

 

KeyurPatel14
Responsive Resident
Responsive Resident

Hii @THENNA_41 ,
Please try below formula:

KeyurPatel14_0-1674022486742.png

 

KeyurPatel14
Responsive Resident
Responsive Resident

Hii @THENNA_41 ,
Can you please try following measure:

KeyurPatel14_0-1674021297665.png

I have taken this as a sample data so apply this formula to your data and if this helps you then accpet this as a solution and give a thumbs up.

Mahesh0016_0-1674022984295.png

Compare =
 IF (
    Compare[CBL            ]=Compare[Column1] && AND(Compare[CBL            ]<>BLANK() , Compare[Column1]<>BLANK()),
    "True",
   "False"
   
)

 

@KeyurPatel14  if both column blank its also False 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors