Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
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?
Hi, @Chrisw97
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |