Forum Discussion
Conditional Formatiing help
Hi pmadam ，
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a column
Color =
VAR _t = 'Table'[Domain]
RETURN
IF(
ISNUMBER(
LOOKUPVALUE(
'Table'[TotalCount],
'Table'[Domain],
_t,
'Table'[PriceDate],
DATEADD('Table'[PriceDate], -1, YEAR)
)
),
IF(
'Table'[TotalCount] >
LOOKUPVALUE(
'Table'[TotalCount],
'Table'[Domain],
_t,
'Table'[PriceDate],
DATEADD('Table'[PriceDate], -1, YEAR)
),
"green",
"red"
),
"green"
)Use the column as the filed value of conditional foramtting of the [TotalCount]
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I get error msg " multiple values was supplied where a single value was expected" . Is it because of duplicated data in it. Please help with resolution
Hi pmadam ,
According to your description, this error occurs when two values are compared to each other, and you need to give both sides of the equation unique values to compare. In the previous code, the applicable case was to create a calculated column instead of measure.Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi pmadam ,
Whether the problem has been solved. If there are other related issues you can continue to provide details below.Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
