Hi, How can I compare the multiple column inside the same tables via Power BI formula and conditional formating? I have a one Table that contains text and numbers from column B:I. Column B:E name called Table A and column F:I called Table B.Column J is my output "YES" or "NO". IF matched columns from B:E into the columns F:I then return the output is "YES" in column J and If not matched any of these columns then return the output is "No" in column J. Data: TABLE ATABLE B FRUIT LISTAREA CODELANGUAGESALES CODEFRUIT LISTAREA CODELANGUAGESALES CODESTATUSAvocado3100ENEU01Avocado3100ENEU01YESAvocado3100ENUSAvocado3100ENUSYESAvocado3100ENUKAvocado3100ENUKYESAvocadoWESTENUKAvocado3100ENUKNOAvocado3100ENUKAvocado3100ENUKNOAvocado3100ENUKAvocado3100ENUKNOAvocado3100 UKAvocado3100ENUKNOAvocado3100ENINDIA01Avocado3100ENUKNOAvocado3100EN Avocado3100ENUKNOStar FruitWESTENINDIA01Star FruitWESTENINDIA01YESStar FruitNORTHENINDIA01Star FruitNORTHENINDIA01YESStar FruitEASTENINDIA01Star FruitEASTENINDIA01YESStar FruitSOUTHENINDIA01Star FruitSOUTHENINDIA01YESStar FruitWESTENINDIA02Star FruitWESTENINDIA02YESStar FruitNORTHENINDIA02Star FruitNORTHENINDIA02YESStar FruitEASTENINDIA02Star FruitEASTENINDIA02YESStar FruitSOUTHENINDIA02Star FruitSOUTHENINDIA02YESWatermelon ENUKWatermelon ENUKYES

Anonymous

Not applicable

6 years ago

Solved

True or False Conditional formatting inside the same tables and DAX

Hi,

How can I compare the multiple column inside the same tables via Power BI formula and conditional formating?

I have a one Table that contains text and numbers from column B:I.

Column B:E name called Table A and column F:I called Table B.

Column J is my output "YES" or "NO".

IF matched columns from B:E into the columns F:I then return the output is "YES" in column J and If not matched any of these columns then return the output is "No" in column J.

Data:

TABLE A	TABLE B
FRUIT LIST	AREA CODE	LANGUAGE	SALES CODE	FRUIT LIST	AREA CODE	LANGUAGE	SALES CODE	STATUS
Avocado	3100	EN	EU01	Avocado	3100	EN	EU01	YES
Avocado	3100	EN	US	Avocado	3100	EN	US	YES
Avocado	3100	EN	UK	Avocado	3100	EN	UK	YES
Avocado	WEST	EN	UK	Avocado	3100	EN	UK	NO
Avocado	3100	EN	UK	Avocado	3100	EN	UK	NO
Avocado	3100	EN	UK	Avocado	3100	EN	UK	NO
Avocado	3100		UK	Avocado	3100	EN	UK	NO
Avocado	3100	EN	INDIA01	Avocado	3100	EN	UK	NO
Avocado	3100	EN		Avocado	3100	EN	UK	NO
Star Fruit	WEST	EN	INDIA01	Star Fruit	WEST	EN	INDIA01	YES
Star Fruit	NORTH	EN	INDIA01	Star Fruit	NORTH	EN	INDIA01	YES
Star Fruit	EAST	EN	INDIA01	Star Fruit	EAST	EN	INDIA01	YES
Star Fruit	SOUTH	EN	INDIA01	Star Fruit	SOUTH	EN	INDIA01	YES
Star Fruit	WEST	EN	INDIA02	Star Fruit	WEST	EN	INDIA02	YES
Star Fruit	NORTH	EN	INDIA02	Star Fruit	NORTH	EN	INDIA02	YES
Star Fruit	EAST	EN	INDIA02	Star Fruit	EAST	EN	INDIA02	YES
Star Fruit	SOUTH	EN	INDIA02	Star Fruit	SOUTH	EN	INDIA02	YES
Watermelon		EN	UK	Watermelon		EN	UK	YES

BA_Pete

6 years ago

Hi Anonymous ,

Please try this calculation in your custom column:

if List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})) then "NA"
else if [FRUIT LIST] = [FRUIT LIST_1] and
[AREA CODE] = [AREA CODE_2] and
[LANGUAGE] = [LANGUAGE_3] and
[SALES CODE] = [SALES CODE_4]
then "YES" else "NO"

Pete

Forum Discussion

True or False Conditional formatting inside the same tables and DAX

19 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting