Forum Discussion
Conditional formatting for "version control"
Hi Community! I need a little help with something that in mind seems rather easy but I am failing to actually get done. As the tittle say I want to use some conditional formating on a table ( or ...
AutoJL If it is a small data, merging tables in PQ can do the job but I will avoid it because it is a slow transformation but rather focus on creating a data model that can achieve the goal. One of the advantages of this approach will be that the solution can be scaled tomorrow to meet other requirements.
I agree with andhiii079845 approach. Basically, you need a common dimension between these two tables, connect both to this new dimension table, and then do the comparison for conditional formatting