Forum Discussion
Conditional Formatting comparing cells between two rows
APPD31 and APPD32 will always be a pair. APPD71 and APPD72 will always be a pair.You know that but Power BI doesn't. You need to provide a hint (like a Pair ID) in the data.
APPD31 and APPD32 will always be a pair.
APPD71 and APPD72 will always be a pair. You know that but Power BI doesn't. You need to provide a hint (like a Pair ID) in the data.
Correct, I'll need to establish a relationship and then check the condition. I'm quite new to Power BI and trying to do the balancing act of learning Power BI but with an understanding I will likely not use the application that much after this.
As for this case. I created a simple bash script to complete the task and will update the DB table and use that value in the conditional formatting equation.
I will close this session but very grateful of the input you gave. Being able to ask questions and get answers from the community makes the task of learning a new application easier.