topic Re: Highlighting the value of a column if it matches with future values in another column in DAX Commands and Tips

Highlighting the value of a column if it matches with future values in another column

Anonymous — Thu, 18 May 2023 11:28:20 GMT

There are 2 columns namely current and new. If values of new column matches with any of the future entries of Current, it means failed and If we find one such entry - the values are to be highlighted. I need Dax solution for this

Re: Highlighting the value of a column if it matches with future values in another column

FreemanZ — Sat, 20 May 2023 08:02:43 GMT

hi Anonymous

not sure if i fully get you.

supposing you have a data table like:

try to

1) plot a table visual with the two culumns

2) apply the conditional formating of the background color for the new column with a meausre like:

measure = IF( MAX(data[new]) IN ALLSELECTED(data[current]), "Red" )

it worked like: