Hi,
I'm working on a report for the following purpose: next month, we will release a new version of our software tool. With Power BI, I want to check if the migration went well, that is, if the new database has the same values as the old database. We are currently running a test environment. I'm building the report but I'm facing a problem.
My goal is to compare values from the table of the old version (Prod_Pompen) with the values of the new/test version (Acc_pompen).
I prefer to create a report where I can select the columns I want to compare. Here’s what I’ve done so far:
First, I created two field parameters that contain the columns of each table (Parameter_prod & Parameter_acc).
Then, I created a measure to compare the parameters:
Vergelijking parameter =
var prod = SELECTEDVALUE('Parameter prod'[Parameter prod Fields])
var acc = SELECTEDVALUE('Parameter acc'[Parameter acc Fields])
RETURN
IF( prod = acc;"Match";"No Match")
After that, I added two slicers in the report and applied the parameters to each slicer. I want to click the columns in these slicers to compare the selected columns with each other in a table that only shows "No match". The problem is that currently all the fields show the result of the measure as "no match".
Can someone help me out?
