Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I want to compare two columns on the same table.
If the Columns match it should return 3.
If thet dont match return 2.
If both are blank return 1.
I want to use these values in conditional formatting. 1 for red, 2 for yellow and 3 for green.
I have tried this, but it wont return 1. Only returns 2 and 3.
Solved! Go to Solution.
@SnymanGrobler
Try
Match =
SWITCH (
TRUE (),
Table[Column1] = BLANK ( ) && Table[Column2] = BLANK ( ), 1,
Table[Column1] = Table[Column2], 3,
2
)
or
Match =
SWITCH (
TRUE (),
Table[Column1] & Table[Column2] = "", 1,
Table[Column1] = Table[Column2], 3,
2
)
Hi @SnymanGrobler
Please try
Match =
SWITCH (
TRUE (),
ISBLANK ( Table[Column1] ) && ISBLANK ( Table[Column2] ), 1,
Table[Column1] = Table[Column2], 3,
2
)
Hi, @tamerj1
This does not work.
My conditional formatting looks as follows:
With this logic it still only returns green and yellow colors. Example:
Do you have any idea why this is the case?
Thanks
@SnymanGrobler
Try
Match =
SWITCH (
TRUE (),
Table[Column1] = BLANK ( ) && Table[Column2] = BLANK ( ), 1,
Table[Column1] = Table[Column2], 3,
2
)
or
Match =
SWITCH (
TRUE (),
Table[Column1] & Table[Column2] = "", 1,
Table[Column1] = Table[Column2], 3,
2
)
Thank you very much, second solution worked.
Match = IF(ISBLANK(Table[Column1]) && ISBLANK(Table[Column2]), 1,
IF(Table[Column1] = Table[Column2], 3, 2)
)
User | Count |
---|---|
53 | |
45 | |
19 | |
16 | |
14 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
17 |